It is about making a future for uncountable trillions of (post-)human beings, instead of the few measly billion our single planet can support.
It is about blossoming new cultures in far off places, instead of stagnation and unity.
It is about expanding the human economy to include effectively limitless new land and resources instead of fighting the same zero sum game.
It is about providing a cosmic lifeboat such that one single catastrophe doesn't wipe out the human race or all life on Earth.
Sorry, I think the burden of proof is on those who say the above is meaningless.
For confirmation just look to NASA's vision, mission, and strategic goal statements, and the report of every blue ribbon commission to have looked at NASA over the past three decades.