That said, I think a key question is if Discovery ends up with a fourth season. By the time Season three is over, CBS All Access will have the Picard show, Lower Decks, and be able to begin production of the MU Georgiou show if they so desire. Given all of that, the Trek brand won't be relying upon Discovery in the same way - and might make a change if those shows end up haviing higher viewership. I could see them deciding to spin off several of the characters onto an entirely new show, and hanging up its spurs.
I think the 4th season is pretty much in the bag already as well.
Like, I can actually see that at that time, DIS won't be the flagship Trek show anymore (I guess that will go to the Picard-show). But - even in their wider show ensemble - it's going to be one of their main shows. Like, "Lower Decks" and that horrible MU-S31-Georgious show are going to be the "smaller" ones (probably with a notably smaller budget as well).
What I can see is a noticeable reduction in budget - As soon as there are many shows concurrently, I guess they want more ressurce-sharing, and having one "stand-out" show (just look at the budget of DIS season 2 opening) isn't that important anymore. But they will absolutely hold on it, even if other shows are more successfull - It's their main prestige show now, and the one they publicly built their new universe on. They are going to keep that.
The one thing I can see is DIS "only" getting 5 seasons instead of 7, if they think oterh, newer shows can have a better Return of Investment. But as long as All Access exists - they will let DIS run it's natural course.