No matter how much people may want to portray this most recent era as a failure, I don't think there's any sort of data that would back that up (but if there is, I'd love to see it). This is from early last year:
Parrot Analytics Streaming Economics System shows how the long running Star Trek franchise has been a reliable money maker not only for Paramount+ but other streaming platforms around the globe. From Q1 2020 until Q3 2024 our model estimates that shows and movies in the Star Trek franchise have generated over $2.6B in subscriber revenue for major streamers globally.
You could sort of, probably make the case that the landscape has changed since then - the fact that there are no live-action series in development would certainly support that, though I don't think it really proves anything other than that the company is in shambles right now.
But the idea that the franchise has somehow been killed in the streaming era? It's essentially fantasy.