He used the wrong earth circumference calculation to estimate his trip to the Indias to convince the queen (it was way off, that's why the Portuguese went around Africa instead), he got really lucky, and the end result was way better than what they set up on to obtain in the first place.
Exploration is a bit crazy and a bit stupid, some people die and a few times we find something amazing that was in non way near what we thought we would find.
I think Mars is - hopefully - going to be a bit like that. We go for one (maybe the wrong) reason, yet we stay for a different one.