Physicist here. Thermodynamics always wins.

It really doesn't matter what we do on the earth -- as long as people and industry exists, we will heat the planet. Either faster (greenhouse gasses), or slower (increasing albedo to capture more sunlight, adding energy with nuclear reactors, etc.).

There are effectively three very long term solutions: (1) kill all humans, and let nature recover -- at least until the output of the sun crosses some threshold in about 250 million years where the Earth fries. (2) Large scale geoengineering, like solar shades between the earth and the sun, or similar means of reducing incoming sunlight. (3) Move all industry off the earth.

Now, these are all very long term scenarios. The problem is, if we don't work towards the technology required to do one of three, all of humanity is doomed eventually. Space tech may seem like a vanity project by the rich, and honestly it often is, but it is also advancing civilization in the direction required to turn Earth into Eden in the far future.

If you look at the planet from far enough away, you stop seeing individuals, their triumphs or their suffering. You just see "solar energy capture cross section".