Here's the first (big FWIW/grain of salt/etc) thing on the decision that's I've seen (besides the TrekMovie article note that 'it's no secret that the show didn't Nielsen chart'). From author Mike Chen on Bluesky.
From the few insiders I know, viewership was actually above expectations and this was more of a "future of the franchise" corporate decision. I'm expecting Trek to be in flux as there are SO MANY variables. Everything from tech stocks to Iran to midterms is impacting Paramount.
Leaving the link to his post here for reference but he has his posts hidden unless you're logged into Bluesky.
I find the idea that anyone is still talking about "Year One" with a straight face pretty frakking hilarious.