Not that it will improve your viewing experience, but SPOILERS below:
Welp. this week's episode is in the can. I guess the only positive thing is that we traded a non-stop parade of nonsense for 50 minutes of boring stuff that, as far as I can tell, barely managed to drive the story forward.
A short list of things that made no sense to me:
1. Where did the bearded guy come from that borg queen left the bar with? They literally showed a shot of her ALONE walking towards DTLA. next ep, she left with a bearded dude and killed him?
2. How come the transporter on the ship NOW doesn't work? Worked fine when 7 and Raffi beamed in and out. Worked fine when they beamed Rios the brain scan thing. Worked fine when Rios beamed in his new family. But NOWWWWW it no workie. I guess it stopped working because the script needed it to stop working. Also what weird alternate universe is this where a kid gets sick from eating a slice of cake or two???? DO THE WRITERS EVEN HAVE KIDS??????
3. How did Q infiltrate the FBI and get into a black site?? We've already commented on the strangeness of Q seeming to have unlimited resources and access despite not having any powers, but this one is pretty high up there on impossibilities.
4. How come Guinan gave such a cryptic message in her astral projection (like, why didn't she just say "this dude ran into vulcans 30 years ago") and worse yet how did Picard so perfectly interpret what she said?
5. Why was Raffi sitting on the ground rubbing her neck for like 8 minutes off camera after being choked by the borg queen? lol Also, I'm pretty sure when you're getting choked and picked up by your neck, you can't make a lot of noise or breathe super good. or at all. For Raffi, it seemed like it was more an inconvenience than anything else.
6. Did Romulan ninja boy have a kiwi accent previously? I honestly don't remember but it seemed super weird to me.
7. How come the MIB got fired for SUCCESSFULLY CAPTURING AN ALIEN AND A TIME TRAVELLER? How come fired MIB guy was able to visit prisoners after he was fired? Why did black site have such terrible security that Piacard/Guinan just marched out after fired MIB man opened the door? This is a VERY poorly run black site! lol WHY did we spent 20% of this episode worrynig about MIB back story and partial redemption?
So those are the more egregious plot nits, but honestly the rest of the episode just seemed like throwaway filler that made no sense. Why is 7 and Raffi bickering a sub plot? What was the net gain of the ENTIRE MIB sub plot? Character moments? As far as I can tell the ONLY thing that moved the story (whatever that might be) forward this ep was deducing some of the borg queens machinations, and coming up with a way to track her.