Best-Case Scenario: Ensuring That As The Biosphere Declines, It Will Do So More Slowly
EDIT
I agree that we live in a unique moment in history. This isnt like a war or an economic recession, where you know things will be bad for a few years but eventually improve. Never before have we known that the deterioration of not just our countries, but our entire planet, will continue for the foreseeable future no matter what we do. As Attenborough says, we can (and should) fight to slow the rate at which things get worse, even though we cant realistically hope for improvement.
We cant hide from the fact that Attenboroughs opinion reflects mainstream science. Even if we halted carbon emissions tomorrow, a significant degree of future warming is already baked in. Under the most likely scenarios, were set for warming of 1.5℃ or much more. The consequences are dire. If we succeed in limiting warming to 1.5 degrees, we will still have sea level rises of around half a metre, killer heatwaves and drought in many parts of the world leading to a decrease in agricultural productivity. We can expect mass migrations, death and destruction as a result, with many parts of the world becoming uninhabitable.
EDIT
It is fashionable in some circles to deny that genuine altruism exists. Whether based on the perception that selfless behaviour is selected against by evolution, or merely cynicism, many thinkers have argued that all our actions are motivated by self-interest. Perhaps we give to charity because it makes us feel better about ourselves. Perhaps we recycle for social status. But your question shows the problem with such arguments. Like you, many of us feel desolate about the inevitable harms the world will face when we are gone suggesting that we care for future generations for their sake and not just for our own.
EDIT
Contemplating inevitable decline reveals that we care not only that humanity continues to exist long after we are gone, but that we care about whether it flourishes even in the far future. Consider those behind the construction of the towering cathedrals of the medieval age. They were often built over more than a generation, so many of those who began work on them never survived to see their project completed. But that didnt stop them drawing the plans, laying the foundations or labouring over their walls. The cathedrals were for the future, not just the now. Dealing with the climate crisis may require similar long-term thinking.
EDIT
https://theconversation.com/climate-change-how-do-i-cope-with-our-planets-inevitable-decline-128593?utm_source=twitter&utm_medium=bylinetwitterbutton