Locking the canonical galaxy to Open only would not "give everyone what they want" - as all players bought a game where they enjoy the privilege to experience and affect the shared galaxy regardless of whether, or not, they ever choose to play in Open or even can play in Open (console players without premium platform access cannot play in either of the multi-player game modes but do, like all other players, affect the galaxy). It would certainly be supported by a subset of the player-base just as it would be opposed by another subset.
splitting the compromised vision into two much more optimal visions is far better than giving nobody what they want to appeal to a mutually exclusive subset of players.
The "open only" version is only more canonical than the other in the sense that "live" mysteries and such will only take place on it, and the actions of players can potentially impact the narrative fdev is going with. There's no way to offer that that doesn't subvert 1 game mode entirely to the other. Otherwise you might as well not change anything.
This would not really be open-only, just the official online version of the game, with ideally, proper networking.
The other game allows the player to choose to follow an fdev narrative that plays out much like how off-line games play out release to release - following roughly the same canonical events as the other game (with updates weekly). But the player in this game cannot impact the bgs of the other and certain hidden things wont exist or exist in different places in this version compared to the other. Consider this the offline version that was promised and never delivered. You still play in an evolving galaxy - but you are free from the manipulation of other players and you are free to discover and experience the events of the game from the beginning (albeit with current ui/gameplay features). Play thru jaques launch - and try and find his location (the way you were supposed to)...or perhaps not find it for months (eventually the game will have npcs find it prior to colonia bubble forming). All the things possible when you aren't tied to the shared online game.
But, this game also allows player mods and player run servers to create their own shared galaxy / story...separate from fdev's. Similar to some community re-hashes of X3 are done. So players who want to be in a shared galaxy but with different rules (such as pve only / etc) can create such a server and play in it. It's just going to be separate from the other game (and separate from eachother unless allowing remote connections).
Neither the "offline" or the "open only" needs to be more canonical than the other, if fdev is crafty enough with their narrative writing - but if the entire premise of threads like this are to dream of ways to make everyone happy, i dont see how it can be done within a single shared game. Since anything that circumvents other players in a game that is supposed to feedback from player actions and have persistent effects to the shared game can't exist without significant compromises to that vision.
So in my above imaginary scenario, there are lots of players able to get what they want out of the game. and maybe a few who are confused (wrong).
As opposed to nobody getting what they want in the current version except those who dont really care about anything going on in the game or those that play so infrequently that none of the compromises matter.