It's probably just comes down to preference. It's like steak. People will get mad at my wife because she likes well done. But she's not wrong to want her steak her way.The real not-so-secret sauce of SNW is the luminous cast and their chemistry. They can (usually) elevate even the silliest material.
This is actually generally true of casting in most NuTrek shows. It was also true of DISCO, and is 100% true of Lower Decks (which was actually aiming for silliness but is also grounded in some of the most consistently flawless crafting of any NuTrek show). But SNW is a spectacular example of it.
Star Trek is the same
But your general point is sound.