For a lot of explorers, there were big bucks to be made.
Columbus was looking for a spice route. So was Magellan. An astounding amount of human progess is driven by the profit motive, which I'm sure irritates a lot of people, but there it is.
Certainly some voyages could be said to be primarily for sheer exploration. Darwin would probably qualify in this area, as would Cook.