Thus is the problem with most anything at this point, but Star Trek seems to have it worse than some others.
What people want from Star Trek is incredibly diverse. I don't think there is a universal "this is what fans want". There is only "this is what some fans want", which also happens to be the exact opposite of what other fans want.
I'm fairly simple. I want Star Trek that is visually consistent with Star Trek and tells Star Trek type stories. The easiest way to do that is to set it in a progression in the timeline "after" the "more recent" Star Treks, ala Picard.
I want things to be different, but the same... what I mean is that I want the world to be the same. I want Klingons to look like Klingons and the Enterprise to look like the Enterprise. We already know what things look like. I want new stories told in that visually consistent world. It's really not rocket science. And quite frankly, even new Star Trek understands that by and large... PIC looked great. Lower Decks takes great pains to look right. Prodigy looks great. SNW is still wrong but has moved closer to looking right. It was really just one bad one, that was just... REALLY bad.
Yeah, agree to disagree at this point.
In my experience and life time Trek was not that visually consistent. It told Trek type stories, but those were all over the map, from horror, to comedy, to Western, to adventure and action. You had Balance of Terror with an extremely somber end, and then you had "Day of the Dove" with a very laugh track style end.
Then you had TMP which said, "Nope, can't look like that any more!" and upended the apple cart. Then you had TNG which did the same, and no 80 years in to the future doesn't make me go, "That's a reasonable update." Then TWOK which upended TMP's apple cart for no reason either.
Change, to me, is in Trek's DNA. I didn't start with TNG though. I don't have that fondness for TNG or its aesthetic. I have change and despite my misgivings on change most of the time Trek is one thing I can handle change with.
Also, if I demand Trek look "right" to my eyes I'll never actually be entertained. Star Trek has been about our humanity's future so I expect it to change based upon an understanding of technology. It's a world meant to evoke our future, and our understanding, from our past. I can't expect it to be consistent because it's not its own period; it's our imagined future.