I agree with basically everything you said, although I've found more things than just the Gorn in SNW to be cranky about. While TNG era never TRIED to get science and engineering right... they tried WAY harder than SNW, which is saying something and NOT a good something. It's like TNG's attitude was "We know we're goofy, but we DO have technobabble consultants, and we try to link some of what we're doing to real physics and engineering" while SNW is like "We don't even like, bother man... rule of cool in a Hollywood hipstery writer way, we don't really know what we're talking about, nor do we care... hey can we get mocha lattes to the writers room ASAP?"
Major pet peeve of mine.
Also, I love Carol Kane as an actress, but she's just Lillian in space, and honestly, I really didn't ever need that. It feels out of place, but shoe horned in anyway.
Certainly, some of my joy in the show also just has to do with it just being better than Discovery (for which I'm like...oh thank god) and just gratitude that at least they're trying to make something LIKE Star Trek.
Lower Decks was a better show. So was The Orville.