Yeah I've actually thought about this.
Like... did Q just re-create existence around him? Or did he pluck Prime Picards consciousness and dump it into the body of Beta Picard? I like to think it's the latter with Beta Picard in the background just like "Wait... what? What's happening?" and then Q and Picard fuck off leaving this poor dude to desperately rely on therapy for the next couple years.