I feel like in the 'cynicism' that's popular in tech circles like this about tech as a career, we tend to forget that many people's passions don't really have a lot to do with wanting to be famous or rich. This is to the point that we apparently can't fathom that someone simply wants to do something without any special stereotypically grand aspirations.
Even in tech, some portion of people chose it for the money and some chose it purely as a passion, such that they would've chosen it even if there wasn't as much money to be made. I know that I would still be pursuing the same career even if I didn't get to work on the things I am currently working on.
Remember that plenty of people work 'boring' jobs like garbage collection, being a janitor, being a soldier or riskier stuff with even worse conditions. Many of them are perfectly content with that as long as that doesn't get in the way of things that are important to them.
So it's entirely reasonable that many people would genuinely be willing to happily sacrifice everything to go to Mars, simply for the sake of being there, regardless of any potential glamourous outcomes.