The ending is the only part of the episode that feels awkward. I know what they were going for, but it doesn't quite work. That said, I'm not sure having it be a "big reveal" would have been better. It still comes down to how well it is written.
One thing I love about the way it's presented now is that first cut to what's happening on the Enterprise. We've been following Picard as Kamin for a while already, but when they cut back to the Enterprise, Picard has just fallen and they're calling sick bay. That threw me for a loop. Then after years have passed on the planet, we cut back to the Enterprise and it's only been like ten minutes. Kamin's life has been compressed, and Picard lives it in 25 minutes. I like getting thrown like that, having to figure out what's going on instead of having everything spoon-fed to me. Maybe that's what bugs me about the ending. For the sake of the lowest common denominators out there, they have to completely explain everything. I mean, come on. Picard: "Oh... oh, it's me... isn't it? I'm the someone. I'm the one it finds. That's what this launching is – a probe that finds me in the future!"
It seems like they could have made it just a bit more interesting, have the viewer work at least some of it out themselves, which would lead to a sense of accomplishment and thus greater satisfaction in the story overall.