So, bit of a mixed bag. I enjoyed Spock smashing bloodwine, and the general idea of the plot, decent Klingons etc. I did not enjoy unexplained spacewar drugs, feels like a very non-Star Trek thing.
That being said, I really wish they would stop harping the "do the thing do the thing" angle every time anyone sits in the Captain's chair. It's been in every show now and it's just such a tired and stale joke that it's moved over time from being funny, to tiring, to outright annoying.
To add to this, I think I've formulated my total issue with the angle a bit better. The whole stealing the Enterprise plot was done incredibly casually, and I think they could have used the time they wasted on The Joke They Always Do (which was quite a bit, this was a notably long one) to make that whole sequence a bit more inspired.
Additionally, I really wish productions would talk to each other more. This joke was literally in the last episode of Picard and the first episode of SNW. Assuming you watched no Star Trek inbetween this is back-to-back The Joke.