I’m not surprised that in general people are against space exploration. Pretty much without fail, in all times and places, people have been against exploration if it were non-colonial in nature.
Except in rare cases like the Polynesians and their highly unusual culture, humans just really aren’t that curious or that enterprising in general.
Space exploration might be a dead end. Might be worthless, pointless, and without any merit at all. But the thing is…you don’t know until you go.