Think about all of the things he has seen, all of the worlds he has explored, all of the green women he has slept with, and when he is faced with death, it shocks even him, to the extent that all he can say is, “Oh, my.” I’m not sure how popular this scene is among the Star Trek Zeitgeist, but I imagine it’s probably hated. I, however, love it. Feel free to tell me how I’m wrong in the comments.
You get me, mah Trek! That’s what it was all about. He faced death so many times in his life, but when it came, he wasn’t alone, but he was with another captain, someone who might have become a friend, but who understood his burdens and regrets. The whole movie is about the similarities between Picard and Kirk, because they each lost or gave up family, love and friendships for their obsession.