Why would you have a nuanced difference about about whether the competition is at an elite level? Skate Canada doesn't make any distinction.
Skate Canada said in a tweet that there are no new event categories, and any team can enter the pair or ice dance disciplines at any Skate Canada domestic event.
Because skate canada mentions domestic events and it is clear to me that athletes who wish to compete internationally, or what would be elite skaters, will most likely find a traditional pairing...
Adding to clarify.
I think Leduc's case is an example of what this policy achieves : allowing a competitive elite athlete in what looks like a "traditional" team to compete as a non-binary athlete, thus getting recognized as such. So in this case, it's semantics mostly to promote inclusion and diversity. Nothing changes on the ice but
the skater doesn't have to go under a specific gender label they do not feel comfortable with.
The other options are :
1)Young girls (and boys but as we know, chances are that the boys would find a girl partner) wishing to pick up partnering skills in either dance or pairs. The difference here, is that they will be allowed to compete in domestic events. Will they place well or high enough to make it to nationals? I think it's possible up to a certain point in pairs... and possible in dance perhaps even with senior skaters. However, what I believe may happen is that the best athletes may evolve to new "traditional" partnerships when they are identified as being able to get further within the sport. The athletes that are driven to compete internationally, and that happens fairly young will have to find a "traditional" partner. So I would see this as a developmental opportunity. There may be some non-trad teams that decide to stick together because they truly enjoy working together, but they will plateau eventually in terms of what is possible to achieve, simply because the code of points is not designed to favour them and the ISU is most likely not going to go that route.
The objective here is
developing skills and allowing for more participation throughout the country. In smaller areas, it may be more difficult to find a partner, so that opens up a variety of possibilities.
2) Some skaters exploring their gender identity may want to be part of a non-gender based team. The proportion of non-binary or transgender people in Canada is 1/ 300. ( 0,33 %) This number is for 15 years and older (Census 2022).
This will allow them to form unconventional teams they feel comfortable with and still be able to compete domestically, whether that team is made of one or two non-binary members. Again, a question of equity, diversity and inclusion.
It is more about the people than the sport itself, which goes with the culture change seen throughout sport in Canada... people first, sport second.
--------------------------------
I believe that what has been mentioned in this thread, focusing on same sex partnerships and their respective pros and cons, is not the reason why Skate Canada has updated its policy, and if it may happen for various reason, it will not produce elite teams due to the current code of points.
At one point, a talented skater with potential may want to get international assignments and get funded. In order to do so, they will evolve to a traditional partnership if they were not in one... just like some skaters opt to do pairs or ice dance because they have more affinity and/or potential doing so than competing in singles, or just like some skaters switch partners because their current partnership is stalling.
What Scott Moir mentioned is interesting though. These new options will provide different "artistic" possibilities. It may fuel some more creativity into the discipline and that may also have a positive effect on "traditional" partnerships.
I apologize for the wall of text.

I thought it may be a good idea to clarify what I think this really means in my humble opinion.