I would have to say the end of the human race itself if we DO get off this loving rock is when andromeda collides with the milky way.
And sunshine is not realistic and the sun isnt shutting down by age, they explained it by some other scientific anomaly.