Picard should've just relived someone's real-life memories from another planet, via touching the wrong controls, or something like with the Iconian planet, when Data got blinded. Unfortunately, with Sci-Fi, more than any other type of fiction, it has that "alien" card to let anything fly, when the show needs it to. Picard got zapped and all that happened to him for absolutely no reason, other than it was in the script. It would never play out in any century, in any part of the galaxy, by any alien species - particularly such a Human one.
There's absolutely no logic in it and it basically amounts to a violation, of sorts, the way it's presented in the episode itself. When Picard grabs a hold of that flute, at the very end and clutches it to himself, it looks like Stockholm Syndrome, to me. And maybe that was intentional, though I seriously doubt it. It just seemed an excuse to relieve the monotony for Sir Patrick Stewart. Had "they" arrived at Picard's living another life, some other way than an arbitrary probe zapping - because, hey, they're aliens - this episode could've been great. But the simple village and quiet life he had wasn't all that entertaining, really, was it? It only worked, because he remembered his Picard Life. Without that crucial element, this episode simply wouldn't hold up.