I see this episode very much the same way as Conundrum. There's certainly flaws, but what you get with a chance to see the entire cast playing the same effect is worth the sacrifice. The sleep deprivation performances here are fantastic
There's plenty of episodes where something is going terribly wrong & it could kill them, but it's rare that their own mental acuity is that thing. There might be nothing more chilling than them just losing it & doing themselves/each other in, which is what it plays like the whole time
I feel like we got a taste of that "crew losing it" vibe in Sarek, but they really go all in on it here & it's wildly engaging entertainment imho.
That scene where Picard tells Data they may have to count on him for their very lives is really gripping because Data doesn't emote & the feeling that Picard loses faith is palpable. The idea that Data isn't registering his desperation just sucks the wind out of his sails & you can see it plainly in the brilliant performance.