Deep geological time isn't very relevant to human civilisations. The Fall Of Civilisations podcast has great long deep dives into what does threaten them, and the score is about 50:50 between climate change and Outside Context Problems.