Here's the thing: Why exactly do these people need to remain together? Picard's quest, and the reason why he needed Musiker, Rios, Jurati, and Elnor, is over. So there's no real reason why Picard has to be on the La Sirena any longer. I suppose Elnor and Soji might want to stay with Picard at his vinyard or something out of an obligation to him, but other than that, what else does Picard actually need to do?
At this point, unless the new showrunners come up with a really interesting story that explains why all these people are still together on the La Sirena, I would think that a good move would be to indeed move back toward a TNG 2.0 situation, with Picard coming out of retirement and commanding the Enterprise-F, with a new crew. Maybe Musiker could be his new Number One, Soji could be his science officer, and Rios could be his navigator.