I always use the Lewis and Clark example of government funded exploration. The benefits of that “waste of money” were great. However we didn’t have a lot of other social programs to deal with at the time.
The naysayers of manned space exploration are most likely descended from those who in 1867 screamed bloody murder over the $7.2 million dollar purchase of Alaska.