That sounds great. Since a thousand years have based since our characters were alive he would definitely want to learn all he could about what happened to civilization after his death.

Also earlier you were talking about a DnD like system, and while DnD can be good for narratives things, there are plenty of other systems more suited to narrative play. There's a game called Dungeon World which would probably be better suited to narrative play. I haven't read it so I can't be sure but it's Powered by the Apocalypse (PbtA) and other PbtA games I've played have been very good for narrative driven stories.