It's turned into drivel, but in a different type of drivel to Discovery.
I love the SNW cast and still do, and I felt it started off competently in season one. But it's been a decline since then.
I think the biggest issue is: fear. The writers are afraid to write. To make new characters, to make new situations, to form new concepts, to have an opinion. They want to stay in the safe sandpit of what they know, rather than step outside of it. Where are our Qs? Our Borg? Our 8472s? Our Duets? Our Visitors? Shelby is like decades later from one appearance, who is the Shelby of this series?
It's like a pen being written on the same spot of paper over and over again, until the paper wears thin.
They hold on (mostly) to characters that they know through shows like TOS. I known Kirk is the main man eventually, but they use him like a crutch as they have the template of him. The have their picture and they're colouring it in.
A character like M'Benga who is for the most part 'new', gets left on the sidelines most of the time. They did some early legwork with his daughter, but gave that up quickly.
Beyond that, they aren't creating or fleshing out new characters that broaden the show's tapestry.
Then when it comes to the stories, it's again fearful. It retreads old ground of Trek, or copies and emulates other shows to great degrees. Now, I know all shows ultimately can take inspiration from others - there's very few truly unique ideas. But SNW copies ideas as again it means not having to think. We've had holodeck episodes. Zombies have been done in media to death.
The musical you mention - done before, Buffy did it for example.
The huge difference is that Buffy's writers had taken the characters on massive arcs of character development, and the musical was this explosion of storytelling that was rewarding because they had put so much work into the backstory. It was years in the making.
In SNW they don't get that. They think they can make them sing, and for it to mean something. That the singing is the thing. But it's not. It means nothing, as they hadn't put in the legwork.
Picard was similar. Insular, scared. The writers more interested in commenting on what was on their doorstep (almost literally) and undoing TNG/the movies so they could erase stories of loss. Again, using the toolkit that other writers gave them.
It's sad though... again SNW has a great cast. Good production values. The universe is their oyster. But they don't want to take it. Because it's DAMN HARD WORK creating new stories and characters.