From a Star Trek fan's perspective, it's interesting that only of the three co-CEOs who's staying with the company, and he oversees CBS Studios, which produces all Trek series.
At the same time, the new ownership has resurrected Paramount TV as a separate division. It's supposed to be the home of streaming services, so there's a chance they'll decide to move the franchise over there, in which case there will be a new boss to deal with.
We'll probably get some clarity in the near-ish future...