It is extremely short-sighted, how we have treated our planet. With oil and gas companies lying to the public about their research for 50 years, and politicians intentionally taking stances that we should pollute more (just because we can), the main issues on Earth are around decision making.
It will not be technology that solves climate change; it will be a reigning in of externalities, correctly pricing pollution into corporate development and taxation, and the recovery of truth into politics and decision making.
It should be common knowledge that most corporations are trading our long-term health for short-term profits; if only the corporations could wait 5-10 more years for profits, they could be had sustainably for centuries, rather than all in a burst today.
We need better decision making on Earth - and better technology. But it's hardly SpaceX's fault that we haven't solved our Earthly crises yet.
But yes, SpaceX is doing a lot to make spaceflight more accessible, and that will yield many benefits and opportunities down the road.