No it is not a HUGE majority. It is the ending most picked but not even all metrics show it as a majority. By any rational standard canonizing Destroy will alienate at least a 1/3 of your fans if not over 1/2 of your fans. Canonizing any ending doesn't work to healing the community over the feelings of the endings it actually works to exacerbate the issue.
This assumes that the huge majority of fans cannot buy into the idea that a canonized ending is more akin to an alternate universe to their own playthrough, rather than the devs telling them they're playthrough is invalid. Other studios have done this before and succeeded. Who knows, really?
The best way to heal the rift the endings made is to do NOTHING to try and change them or canonize one or reference them in future games. Let them pass into memory and move on to a different series. Oh and guess what they are.
In your subjective view point, of course.
Do not get me wrong picking an ending that is your favourite and making it a canon ending will likely make YOU feel better but it will p!ss people off who don't share your SUBJECTIVE view point. If they made control or green space magic canon I'd be royally p!ssed. So because I am not a psychopath I can take a situation that I would find irksome and use these feelings to EMPATHISE with other people if my preferred ending was picked. So it really doesn't take much effort to see why they didn't go this route.
People are going to be mad no matter what direction Bioware takes. Alan's just speculating on what will make less people mad, as are you.
And people get mad at a lot of things. And for reasons that perplex me, this seems to be especially true of video games. We don't always have the mental bandwidth to empathize over every little thing people get mad at, especially when we genuinely don't understand the anger. Doesn't make one a psychopath.