I never watched the Buffy musical episode. It's indulgent. And not in a good way.
I watched the first season of that Discovery show and felt deep hurting in my brain. It reminded me of almost every series I've dropped. You've got a protagonist set up as the savior of the universe, only, she's unlikable, and the world bless'ed revolves around her.
Apologies to Miss Green, but she cannot carry that weight. Even if you made her a total joker to start with, and boy howdy did they, there is no redemption. She's the same joker she was in the pilot, and I'd wager a bet she's still an bottom up to now in the series, occasionally crying.
Honestly, it's surprising Star Trek managed to avoid such a premise for so long. The early 2000's star wars were all about the unlikable center of the universe, going around like a human trash can, scowling at everything.
The duty of the writers and producers is to make us like the protaganist, and give a poo about the things they are doing. No matter how Strong and Brave they may be, if they're a joker, they're a joker. And if I want to see that, I'll take another job at a supermarket and look to my manager.