I love the atmosphere in this episode. They did a great job making this a eerie at all the right places esp. when they're all watching the fragmented footage from the future, and when Picard is trying to wake 'himself' up.
I have no problem with the ending either. Picard was grasping at straws; he didn't know for sure that going into the vortex would save them. All he knew was what originally happened resulted in the ship's destruction, so any alternative must be the preferable one!