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.
Here's another one to ponder.
I commented on social media that even though the press reports say the question is open, his "farewell" letter in the reports read to me like someone on the way out talking to his successor. And Brian Tatosky (one of the VFX team) replied:
So it sure seems like the end of the road.