I disagree. The Earth will end, but not in the timelines they provide. In a million years it is unlikely we won't have the technology to hold the sun back from expansion. All we need are orbiting superconducting supermagnets to hold back the sun, tame volcanos, hold back cosmic radiation, etc. Asteroids would be nothing but mining prospects to humans in 1 000 000 AD.