I don’t think you’re necessarily missing anything. Lower Decks is probably my favourite Star Trek series by a decent margin, but I think that people’s varying tastes is part of the Trek experience.
Like the first Star Trek I ever watched was TNG, with a partner who hated DS9 because of how far it was from the much more utopian tone of TNG. My best friend, however, loved DS9 most of all for that exact same reason. I can’t tolerate The Original Series because of how campy and cringe it is, but I have friends who love it for that.
If you hate Lower Decks, then your perspective is one I can’t really relate to, but that just feels like regular old Trekkie solidarity to me - with a show so varied, inevitably there’s going to be diverse viewpoints. That in mind, I’m not going to try and change mind, I’m just going to highlight why I love Lower Decks.
My favourite bit about Lower Decks is that it feels like a love letter to Trek, in all its forms. There’s a lot of references I don’t get, but I don’t need to get them to feel the warm fuzzies of knowing this show was made by people who are, first and foremost, fans of Star Trek. I like utopian sci fi because the state of the real world means that I can find real hope in the fantasy because in my heart, I believe in humanity.
Alongside all of that idealistic space exploration though, Lower Decks doesn’t shy away from the more pernicious aspects of Star Trek, and Starfleet/the Federation. The humour isn’t always my taste, but I think they use it well to poke fun at Star Trek, the show, but also the world within. The sometimes critical lens that is taken is part of why it feels so much like a love letter to Trek - if you truly love something, you’ve got to take the bad with the good and not pretend that everything is perfect.
A few years ago, I read about how Mary Molony was an Irish Suffragette who disrupted a speech Winston Churchill was giving in Dundee by ringing a bell every time he tried to speak. She wanted him to apologise for remarks he had made about the women’s suffrage movement.
I remember when I read this, it reeked of something awesome that you find online that’s actually false (the story was shared on social media via a captioned photo with no sources), so I went digging for a proper source to check. I found some newspaper articles from 1908 and I learned that this event did happen, but also that people fucking hated Molony for this. There was a lot of “see, this is why everyone hates the Suffragettes”. (Sorry for saying this and then not sourcing)
It makes sense that people would be salty - Churchill was an asshole, but also a great orator, so I can see why one might be disappointed in missing the chance to see him speak, but I was shocked at the level of vitriol aimed at Molony and other Suffragettes from the time. Until this I hadn’t realised just how unpopular they were at the time. It’s drastically changed my perspective on protests and public perception.