Sadly, yes, a lot of people want to be entrepreneurs for prestige/wealth. In their imagination they skip ahead to a fantastical ending: being rich and respected.
I find this disturbing. How can someone be useful to others without an idea of what that even means? How can one provide a novel offering without even caring about it? It's an expression of missing craft and bad taste. These aspirations are reactive, not generated by something beautiful (like kindness, or optimism).
Fortunately it is not hopeless; aspiring entrepreneurs can find deeper motivation if they look for it.
(I like to give the following advice: it is easier to first be useful to others and become rich than it is to be rich and then become useful to others. This almost certainly requires sufficient empathy and care to have a hypothesis and be "post-idea".)
Entrepreneurship is the act of creation, a noble activity