First there is a whole spectrum of people interested on adventure, breaking frontiers, understanding science from outside the conditions on Earth, not just N-E-R-D-S.
It reminds me when I was in the US and two very prominent politicians were arguing on TV against each other about who was less of a nerd, have no relationship with them, like they were a pest or something.
It was like the stereotype of empty brain US football player who gets all the chicks by downplaying all people smarter than them and caring only about looks.
The challenges and adventure of not having water, facing problems like living on Venus clouds, etc.. are exactly the main reasons to go there. Doing what no other person has done ever has lots of advantages for the individuals doing it and human society as a hole.
For example when the first vehicles were sent to the moon we were able to discover that most rocks or sand were not affected by erosion or air pressure so they had properties not seen on Earth.