The evolution of any franchise is either jumping in at some point, or daring to jump in at the first episode based on what others say. When I first saw Trek as a kid in the 70s, I didn't start with either pilot - the chances of which were very low. Infinitesimally low nowadays, too.
Since I was in a time when we had TOS reruns du jour and no TNG or other spinoffs, we in that time just flicked channels after flicking anything else flickable. One either dug the characters and plotting or one didn't. Quite different now with so many formats and characters, there will always be a Trek to appease someone's interests out there.
Picture this, in 1987 or 1991 or whenever: Detractors of the then-new TNG, regardless of season, still may not have noticed that people jumping on board then might have looked up the old shows and found magic in them despite the lack of "the pretty". TNG had lots of "the pretty" compared to TOS. Fast forward a small handful of decades and things are prettier now, even the dank teal/orange slathered palette* stuff sometimes has superior advantages that filmed models can't have, and that's not going to stop people from looking up older shows too. The cycle will continue forevermore, therevermore, etc.
As people see more of it, they'll have their favorites and just stick with that format/style. Revisiting old stories they may have thought were clunkers may or may not happen too.
Personally, while I find DS9 to be my overall favorite as it feels the closest to TOS**. Yet, despite that, I've gravitated toward TNG the most in recent decades when it comes to rewatches. Then a third of TOS. Then a third or so of DS9, but - dang - that's a fairly spectacular third! (Keeping in mind that DS9 has more than double TOS's story count.) DS9 is easily better than TOS at times, and yet the 60s original still has some verve to it that supersedes its successors. The original show finding its way and taking more risks appeals, especially when it works. All that said, my next DS9 rewatch will be the whole 7 seasons this time.
As for everything afterward, there's maybe 10 or 12 VOY episodes I'll rewatch, but those don't quite rise to the same highs of previous and some future Treks. IMHO, it's solid but a little nostalgia waxing, especially as a great idea was ditched iin favor of "TNG-lite", possibly because DS9's rartings were faltering and they wanted to go back to basics despite the premiere setting up the wildest possible premise.
Every couple of years I'll return to LD or PIC season 3. PIC3 does peter out, but IMHO it gives the TNG crew a far better sendoff that the 90s partytime flicks had. LD's gems are "a loving tribute and parody in the vein of Futurama and Rick&Morty".
I couldn't stand ENT, even season 4 the last time I tried, it's too fanwanky and I've rarely gotten into prequels in the first place. Some do, some think they're better than the shows that made the prequel possible, it's all good.
DSC and SNW both started as prequels, are a bit hit or miss for me, but have millions of fans too. Some social media post talked about something something comedy and relationships and dared TNG users to tune in. Good luck for those who do. Regardless, top the Trek cake with the flavor of icing called "IDIC" and if I don't like the episode or spinoff/prequel/nameit it's easier to leave it be. Hate watching is as illogical as everything else. But that said, I did like the new Harry Mudd, from what I remember...
Future production teams might circle back to tested formats, others will try something different. Or both. It's cyclical, rinse and repeat.
* well, somewhat, of 16,777,216 hues in a typical 24-bit palette of yesteryear, or the billions today, limiting to two slices of the color wheel is still comparatively underwhelming
** in spirit of having a new frontier and exploring some big stuff that couldn't have been done in the 60s, and without the trappings of TNG's "utopia" while working to balance how making non-utopia work in the background, like how a duck on a lake looks graceful but it's paddling like squirrel's quest for nuts in a parking lot underneath