The problem is that under that top tier of Trek and an upcoming D&D series and whatever other original stuff you care about and a few Paramount movies the service's content quickly falls to z-grade dreck (in my eyes at least).
Pretty much exactly this.
This differentiates it from the other major streaming services, in a bad way.
Like:
Netflix - Huge amount of content, there's a lot of trash, but it's so wide that there's almost always something you'd be okay watching. There's a real depth of content as you find stuff you didn't even consider or know they had quite regularly. Overpriced to get 4K so I regularly cancel it but that's their separate stupidity and most people don't (either don't bother with 4K or don't cancel).
Prime - Often something good, again a lot of trash, but also some gems, and most importantly, it's a whole variety of services for Prime, not just video, so you probably don't cancel it if you are using the other stuff (I will admit Prime is looking a bit more threadbare these days but that's more because I order less and less from Amazon - their main store has gradually been buried under a slow tide of total crap - it's more like visiting some dodgy down-market department store from the '80s than the "Oh I will instantly find the thing I want!" that it was 5-10 years ago).
Apple - Pretty much only good shows. They basically Nintendo Seal of Approval'ing this naughty word. I mean, not all of them are for everyone (I've had e-bloody-nuf of Ted Lasso and his annoying pals - only the chicks on that show are ok), but fundamentally you're get particularly good 4K visuals and sound (visibly better compression than Netflix) and good shows. Watch and cancel, but still regularly get for a month or three.
Disney+ - Worldwide this is basically everything that's on Disney AND almost everything that's on Hulu in the US. Again that's quite a depth and breadth of content, from mid-tier TV shows to ESPN sports docs to MCU/SW stuff. I do think it may be at the "beginning of the end" of it being a good service given several the shows they're deleting entirely are pretty charming ones, but they kept me subscribed for a long time.
In the US and some of the world you then have HBO/Max, and in the UK, Sky/NowTV. Too different to discuss in detail though NowTV has most of the same prestige shows as HBO/Max, but point is, it's a prestige TV deal, for the most part, and you're likely to subscribe on that basis.
And Paramount+? It's Star Trek... and.... and.... I dunno? Yellowstone if you're into that Dynasty-type stuff. I hear it's good, but not for me. Then the rest appears to be both utter trash and no breadth or depth of offering. I just can't see ever subscribing for longer than the seasonal run of Strange New Worlds (catching up on the other shows as I go), maybe not even all of that - I could probably wait until the season is over or mostly over.