The cold, harsh truth is: I don't expect anything after this. I'm braced for this to be The End. It'll be a pleasant surprise if that turns out not to be true.
I think it's the endish.
Discovery is done. But Starfleet Academy is almost positively set in the era, so Discovery people could pop in.
All of Trek's P+ shows spun out from Discovery except Picard.
Except Picard. And Lower Decks. And Prodigy.
There was one show that spun out from Discovery. Possibly/probably two with Starfleet Academy.
I don't really count "Short Treks" as a show, it's like, Discovery bonus material with one Picard toss out.
Discovery has been... controversial. It got some acclaim. It also received a fair share of backlash. If I were a P+ exec, I wouldn't consider it a slam dunk to just keep doing Discovery stuff, but I wouldn't write it off either. There is probably room for something generally-Discovery adjacent and something not. If they have the capacity and desire to run two show productions, going forward it's a better/more diversified bet to do a Discovery-related show and a Non-Discovery related show.