Or take the early sea voyages. Not only were there endless worries about things that were ultimately nonissues like sea monsters or falling off the edges of the Earth, but there were endless very real dangers awaiting which we had no clue about or how to deal with - scurvy, rogue waves, and much more. In the aforementioned Age of Sail, it was just expected that a significant chunk of your crew would die. Yet somehow we pushed onward and outward.
And the infinite possibilities of space are going to absolutely dwarf all previous frontiers in terms of interest and potential.