Reddit mentions of Death from the Skies!: The Science Behind the End of the World

Death from the skies! is a good place to start.

Probably the most egregious error is the implications of the collision of the Milky Way with the Andromeda galaxy. There will not be a mass slaughter of star systems as implied in the slideshow; for as densely packed with stars as our galaxies may appear to be, there is still a tremendous amount of space between even the closest star systems. Collisions would be extremely rare, though there may be some close calls.

Planets that orbit far from their stars may be perturbed enough to be torn away to drift in the cold dark of space. Something orbiting as close to its star as we do to ours would likely not suffer this fate.

Star formation WOULD get a boost as interstellar gasses collide and collapse, but again, shit's far away, yo.

Drifting to the galactic core may be a bit problematic, because radiation sucks, but being flung into intergalactic space isn't as bad as it sounds. We would still have our Sun, and if our Sun was a bit younger, we'd be fine, except, well... keep reading.

Because of this vast distance between even the closest stars, the Andromeda Galaxy will only have about as much brightness as our current Milky Way, so if somehow we're still on Earth when this happens, if you were in a city or even a normal suburb, you wouldn't see much if anything at all. But that won't happen, because...

... it's perhaps not complete misinformation, but it is glossed over: the effect of the brightening of our sun over time. We are looking at the end of complex multicellular life on land before 250 Mya, which is a depressing thought, since such life only really got going 250 Mya ago.

What we could tolerate will probably end 100 Mya before that, because the more complex you are, the harder you're hit when times get tough. Complex life on Earth thus follows a ballistic arc spanning a half-billion years.

There's a lot more fascinating stuff concerning our eventual end(s), and a great place to start is Phil Plait's entertaining book, Death From The Skies!

Sleep well. ;)

I recommend you read Death from the Skies! by Phil Plat

IF the earth was able to survive the sun's transition into a red giant then Supe's would gradually lose his powers as he uses up the yellow sun radiation stored in his cells but is unable to replenish it.

There was a great Elseworlds story that addresses this BUT because it's somewhat of a spoiler I won't mention the title.

Those who don't know what I'm referring to and don't care about spoilers can click here to find out.

EDIT: If anyone is curious as to just what will happen to earth as the sun ages I suggest checking out "Death from the Skies" by Phil Plait a very interesting and fun read.