I honestly think that, in-universe, Q should just snap his fingers and change STO to reflect the Picard show, no in-universe explanation given other than Q's whim. Besides, all the players would know and understand the real world reason for the change anyway.One of the devs has said they're willing to rework the games timeline to fit with the show, but they're also willing to treat STO as just an alternate timeline from the show.
They're going to wait and see.
I'd hate to see Star Trek Online slide into irrelevance the way Star Wars: The Old Republic did once Disney declared that game non-canon. Especially now that Star Trek as a franchise is on the rise again.