Yo do bring up some good points here and I will reply to them in order.
1.OK, I admit that stating that 99% was crap may have been an exaggeration. But the times I've tested streaming, I haven't found much worth to watch there except for the series I actually bought the streaming service for. As a matter of fact, I do have a paid subscription to one of the bigger companies in my country to follow a certain hockey team's games. That service includes some channels for movies and series which are downrigt horrible. When I skip through the menu and a fifth-rate doom-and-gloom movie like "Greenland" shows up for the umpteenth time, then I really wonder what I'm paying for.
2. Fortunately I haven't paid multiple months for any streaming service so far so it has been easy for me to get out of it, the fists time when they cut the series I was watching, which i described in an earlier post and later on when I wanted to take a look at DSC and PIC which were both big disappointments. I could as well have burned the money.
3. I do remember when one of the big channels in my country scrapped DS9 after one season. It took me ten years before I managed to watch the series from start to finish and find out how good it was so I won't come up with any excuses about thinges being better before. But so far I haven't found anything worth wasting money on when it comes to streaming either.
As for series, I don'rt buy series on DVDs if I'm not 100% sure that I want to watch the whole show. I did that once with a series which started good and then the channel was removed from my TV service so I bought it on DVD to find out that this series got worse and worse in the last seasons. Fortunately I hadn't paid that much for the box and I managed to give it to someone who might have appreciated it more.
4. I will switch Internet provider in the middle of June and that might make it easier even to watch streaming services, so we'll see what happens. And when it comes to series and such which I really like, then I'll stick to home media. However, there is a problem with Star Trek DVDs from Paramount which I have brought up elsewhere on this forum, but that's off-topic when it comes to this discussion.
When it comes to Star Trek, the problem as I see it is that it's removed from the major networks and therefore it can be difficult to attract new fans.
That's totally reasonable. But on the last bit there, you're still assuming broadcast networks are the only/primary/best way of attracting new fans. Broadcast is a shadow of its former self, and it doesn't tend to attract younger viewers very often in general. If anything, Netflix is probably the best place to go for that (and this era of Star Trek was on Netflix for a long time outside the US). The switch to Paramount+ is risky, but their goal obviously is to make Paramount+ (or whatever it winds up being called after the inevitable further mergers with other streaming services) a genuine competitor for Netflix and whoever else comes out on top of the streaming wars. And if they fail to achieve that, they still always have the option of selling all the shows they've already made to Netflix or another streamer or even releasing them on broadcast channels (or doing several of those things at once). TOS found the lion's share of its popularity in reruns throughout the seventies, so even if this era is late to reach people's tv screens it can still eventually find new fans.
Plus, even if Trek isn't attracting new fans, that doesn't mean the franchise is doomed as we already talked about all the previous eras in which the same issue already happened before.