Standing on the bridge of the Enterprise is and always was analogous to any naval vessel, not a Starbucks. God but I miss the days when series like these were written by people that had actually served, and I don't mean have or should be serving chai soy lattes.
You can have humor in war, conflicts, moments of human weakness etc but none of those belong on the bridge of a ship.
I watched Tom Hanks in that little seen naval drama Greyhound a while back and it's an exemplary portrait of a captain suffering the stresses, physical, emotional and moral in a battle.
Weaknesses belongs in the privacy of his cabin, jokes in the mess and the chain of command is sacrosanct, there are no temper tantrums on the bridge.
Mike was absolutely right about how an utter lack of verisimilitude can disengage the viewers because they may not quite know why the show doesn't work, but their brain does, and it's noticing that all of these fuckwits should be running a collectivist vegan cafe, not a starship.