This personal sniping needs to stop now. I realize this is a debate that nobody can really win, and I'll post some of my own thoughts separately. But I want everyone in the thread to settle down a bit.
Speaking only for myself, I'm in general agreement with a lot of this.

I think SNW does a pretty good job of updating many of the TOS elements, and does so far better than the early seasons of Discovery. Which is not to say I find some of those aesthetics bad either, but I totally understand the complaint that they don't look like they fit into a TOS era prequel.
I'm of the mind, personally, that it would also be possible to use straight TOS effects successfully like what was done twice in later series (in DS9 and in ENT); the argument that modern viewers would see it as too outdated doesn't really wash with me, because if that were generally true they wouldn't be able to enjoy the visuals in TOS. Every series is naturally a product of its time.
I also understand the complaint that sometimes the show runners don't necessarily have
good explanations for how visual changes and other things in modern series, and that too comes with the territory. I myself have never liked how the Klingon appearance in "Trials" was treated as if Bashir and O'Brien had never seen non-ridged Klingons, because the whole thing is rather silly and could have been ignored. But that's me.
To use a non-Trek example of crazy visual problems, one could read through some of the IDW Transformers comics. For various reasons, if you follow the issues regularly, one of the problems you notice is that the art style is seldom consistent. Characters will sometimes switch designs between issues with practically no explanation, often because in RL they had a newer toy released, and then a few issues later they'll switch again to a model that isn't accurate to their prior comic models or to an existing toy variation. There's a point in the All Hail Megatron arc where the majority of characters suddenly have their G1 style character models for a bit.
Oddly, one of the few times such a change actually had story relevance, the change wound up being unusually short despite the new form being a lot more badass. Megatron got beaten to the point of near death by Optimus, losing his G1 body, and Shockwave transferred his mind into a
sweet jet body. Megatron then had his G1 form turned into human scaled copies of his pistol mode and made sure they were distributed to humans who feared all Transformers, with the goal that Prime would either have to stop the Decepticons or fight and harm humans who were otherwise innocent. He only kept the jet body for a few issues, for whatever reason.
This isn't to suggest that the IDW stories are less enjoyable. Only that the art style can be confusing over time even to a nerd like me who's very familiar with the lore. Some of that was due to Hasbro having certain requirements related to the toys, some of it is simply different art styles by different artists.
To IDW's credit, it's not uncommon for one set of art styles to stay reasonably consistent if the same artists work on the whole arc, and their story continuity is independent of the original 1980s setting of the starting franchise. So there's no continuity problems if the story is set in the modern day and Starscream turns into an F-22 instead of an F-15. They even did some interesting visual things with
Shockwave's origins, establishing that his Decepticon form was originally a form of punishment by the corrupt pre-war Senate for leaking information to outsiders. They basically put his mind into a new, seemingly more primitive body while also severing his emotional core, unwittingly making the new Shockwave into a being of purely evil logic.