I didn't take it quite so literally. It's more about taking a chance to be the person you want to be.

Q put it best:

"This is the man you are today. And you should be happy! You have a real heart beating in your chest, and you get to live out the rest of your life in safety: running tests, making analyses, and carrying reports to your superiors."

I just finished (re)watching the episode a few minutes ago, and it's a personal favorite. But that bothers me a bit too. Afterall, the "real" Picard was kind, respectful, and listened to his crew, even those who were not on a high-flying command track in life, and surely in other contexts he would not say that there was anything wrong or defective about a life lived in that way.

But he was comparing it with his own previously lived dreams, ambitions, and experience. As someone who doesn't aspire to be famous, wealthy, a leader of many, etc., I don't feel it's a knock on me. I'm quite deliberate in choosing the life I have, particularly my family life. It's worth noting that Picard never had a traditional family life, which for some people gives life meaning. He gave that up for the life he did have.

I think it wasn’t just that he was an ordinary astrophysicist, but that he wasn’t very good at his job and you could see it in the way people treated him. He was unwanted and looked down upon.