Regardless of what any of us think of Star Trek 2009 or STID, the numbers say they were a success in ever meaningful way to any bean counter. folks can say they were are failure... but the numbers say different, which is why not one but two new movies seem to be in the works.
Likewise, with DISCO, they seem to be happy with the results... especially since CBS AA managed to get Netflix to pay for it and CBS AA retained the rights. We'll never know exactly what something like DISCO brings in in actual revenue because no streaming service breaks out viewing numbers, but the fact that they seem to up to 5 other shows in various stages of production says something.
The real litmus test as to if people really want more of the TOS/TNG formula will be to see if The Orville makes it. Its being put up against actual viewer demand thats paid for by advertising... so if people don't watch, then the show doesn't pay and it won't make it. S1 ranked a pretty lethargic 63rd. and it was questionable if FOX would give it a second season, but it did make the cut... though we basically got nothing for 2018. S1 was a mere 12 episodes and season 2 will only be 14 episodes... which means FOX isn't putting enough faith in the show to order full seasons. Don't get me wrong, I enjoy the Orville, I think its a spot on update and a modern homage to Trek, and I'd love to see it succeed, but its numbers will have to come way up for it to have a chance to make a run anywhere near 70+ episodes... and validate the old formula.
Unfortunately, I don't think the old formula is how people watch anymore... I certainly don't... I think streaming content is actually starting to follow the formula used for years by the BBC... which is that they come up with a project, budget it and shoot a 1/2 dozen to a dozen episodes and thats it. Maybe if it gets good reception they will do another run... but Most of the shows aren't seen as long running continuing series. Which makes sense as TV in the UK (as I understand it) is taxed on a per unit basis to pay for BBC content... which means they have basically had the streaming formula forever.
Streaming sites need new exclusive content to make them relevant and to keep subscribers, so where the advertising dollars is what drove "free" TV product, subscribers drive streaming product. Part of what makes streaming services interesting is that the exclusive content is available all the time... so new subscribers can discover shows that have been around for years. People lament that they have to pay a lot more money for all these services, but I think what most people do is they pick 1 or 2 and then if they get tired with one they rotate to a new service... even if you only pick it up for a few months. AA has been continuously adding new content.. and some of it, I think is good, while some I don't care for.
Michelle Yeoh was a standout in DISCO, so she'll be able to carry a new show... we'll have to see how they decide to do the format, but I expect sort of a Trek version of "The Americans" (for lack of better insight at this time). I think the idea will be interesting and entertaining, and with most stuff I watch... it comes down to good writing, decent plots etc.
I always thought one of the tenants of Trek was about embracing diversity... and the different products certainly do seem to be diverse!