When Memory Omega was started up in 2017, the idea behind it was to build a database of information solely from the novels and comics, which, with a few exceptions, since 2001 had been based in the "novelverse" and relaunch continuity. From 2005, these stories became the new "canon" to many and was certainly going to be the basis of the "main continuity" for the wiki.
When Discovery came along in 2018, you could still squint a little and have a fit in to the continuity established in the TOS novels and the various 23rd century series. With the arrival of Picard in 2020 and the vast amount of information which chronicles a very different 24th century than was explored by the novels, we found ourselves in a similar situation to Star Wars fans when the sequel trilogy began.
Decades of continuity established in the SWEU, rebranded as "Legends", had been cast aside and replaced with a new status quo. Still, the old information wasn't removed from Wookieepedia, it was siphoned off into a subpage with the "Legends" prefix. That way the canonical information could be neatly displayed on one page, and all of the information established in the "Legends" continuity on the other.
In my mind, this represents the best approach. Having a main canonical article and, using Jean-Luc as an example, would have all the information from none-contradicted novels and comics (Stargazer novels, pre-Death in Winter novels, etc.) and then move on to the Star Trek: Picard stuff. The "novelverse" page would then have all the same background information (with contradictory additions) and move on to the post-Death in Winter stuff.
In my view, this clears up the potential mess for articles in including so much information in a alternate continuities section on a page.
Of course, as this is a community, we could pursue other options. If anyone has any other ideas, please write them up below.