I agree, though I'm still wondering who thought it was a good idea to turn Pike into Martha Stewart in the second season; he spends more time in his quarters cooking than Captaining the ship. But then, considering the "Lower Decks" tie-in last week and this week's musical episode, I think the show may have gone completely off the rails and won't find it's way back.
I think what's happening is that the entire franchise has decided to be completely self conscious about "being Star Trek" as opposed to creating a coherent fictional universe that happens to be presented under the name "Star Trek." In other words -- Meme Trek.
There's been discussion, both positive and negative, in various places about the new SNW episode 'Subspace Rhapsody.'
In short, I thought it was brilliant.
It had the potential of being wrong in so many ways, but was woven together to combine character history and development, while serving the plot of the story line. And anything that was silly was silly in the right places.