OK, to the original question... I don't think I'm aging out of Star Trek, but I would say that I don't enjoy modern production aesthetics as much as I liked '90s and early 2000s aesthetics. That may well be a product of when I grew up, but it could also be that aesthetic pendulums swing ... for instance, right now the rapid increase in how easy it is to do computer-generated VFX has led us to a very "more is more" attitude in productions, but I doubt that will last forever. In fact, one of the things I enjoyed about Season 1 of SFA is that it wasn't quite as "whiz bang wow" as the other streaming-era live-action series. But in general, even though I often enjoyed the characters and stories, I had some trouble connecting to Discovery and SNW just because I didn't like the style as much.
This TrekCulture video does a pretty good job explaining those stylistic things:
This TrekCulture video does a pretty good job explaining those stylistic things: