Video games are the answer. Video games know:
|Don't worry, there's a better link below...|
Turns out the answer is a whole lot of apocalypses, aliens, robots, and the humans holding on.
Norbert Demeter made this awesome infographic, putting all the future locations of sci-fi game universes in a single timeline. We're in for a rough ride, and one that doesn't make much sense now, but if Nintendo can cram disparate events into some kind of canon, I'm sure one of you can work the same magic here.
Just get yourself a gun, of the laser persuasion if possible, and start stockpiling cans of beans. You'll thank me later.