Yup. What won out was comfort food viewing. Which is fine, but at least be honest about it. Don't tell me Trek is pushing any limits or groundbreaking or anything.
I wouldn't go that far, it's more after experimenting with various things they have a much better idea of what works and doesn't work, some experiments were highly successful, some weren't.
Now that things are getting rougher, they will take what they've learned to make safer bets.
Picard was always going to end season 3, its the middle group between a mini series and full series, but Discovery is THE flagship Star Trek series for Canada Trek (what I call New Trek), yet its entire run has been completely eciplsed by Strange New Worlds which has the highest audience rating on Rotten Tomatoes of any Star Trek 1st season since the OG Star Trek. It just doesn't make sense having Discovery be the Flagship anymore when its last season got have an audience scorw of 20, one fourth of Strange New World.
So I believe that post season 5, unless Discovery has a shockingly popular home run of a season 5, will get cancelled in favour of either increasing the episide count of SNW so they can stick it on CBS, or create a new less gritty Star Trek series, possible Star Fleet Academy (I give it a 50/50 of being dumped for another idea) or in favour of the rumoured Seven of Nine spin off which my hypothisis see her as Captain of the Enterprise F.