Started out strong and that fucking Duke Nukem twist got me, jesus.
And I didn't mind the end; a nice hard development to an in-universe callback is a great alternative if you want your own Q. I wouldn't say she lacked charisma, rather they clearly want to set them up as misguided antagonists so the contrast between her words and Q-like arrogance felt intentional and justified, which is why it was backed immediately with Space McFarlane's philosophical disagreement. Same "you think we're bugs, but you're dicks and actually humans know a thing or two!" thing, though that makes more sense with Q since he's an audience/author proxy rather than an in-universe race ascended to universal oneness so it's a little ass-backwards (since the basic Trek gimmick is that in-universe humans are a little more evolved than us so they have an example to impart).
But the middle fucking dragged, damn. You expect Trek characters to always do the dumb option, but they hypothesise and rationalise a choice as they go. These idiots had all the information they needed after the mausoleum, and we had to watch them forget about investigating and just trudge to the next vignette. Sure, get on the convenient boat you fucking retards, I wonder what'll happen??