It's interesting that we generally suppose either we'll achieve some super-greatness as a species or die out in some horrible cataclysm.
How species-centric.
As the author notes, a long, slow, fizzle into nothingness seems much more highly probable than some dramatic ending.
As an exercise, what do the democracies and the people in them spend their money on? Not space exploration. Not even war -- the last "real" earth-shaking war was well over 50 years ago. Lately it's all been bush wars. We spend more and more energy and money on ourselves. It's not the species, it's the comfort of each individual.
What do people value and celebrate? Adventure and discovery by moving out into the Solar System? Heck, there's already a serious movement among scientists to eliminate or seriously limit human exploration. You see, we could contaminate the places we visit.
I could continue with examples, but it's seemed obvious to me for many years that, as far as moving towards the conquest of space or self-destruction, we're doing a lot of plugging in, turning on, and patting ourselves on the back about it. But not a lot of exploration. Not only do we not live in a culture of risk-taking exploration, we actively view our presence in the universe as an evil and do all we can to avoid making any kind of permanent mark at all.
I fear over the long term we will succeed at this.