I think fascination with apocalypse is the fear of our individual mortality combined with the fear of missing out.

Ah, yes - The Jupiter Effect: https://www.goodreads.com/book/show/3400930-the-jupiter-effe...

Forward by Isaac Asimov? I'm surprised he would have his name associated with this.

Not just any foreword, a pretty big endorsement. You can borrow the book from the internet archive to read the full foreword, but here's the last bit:

    And in the end, it turns out that something will happen in 1982 that just may—
    No, no, read it for yourself. Read it carefully and you'll find it far more fascinating than the tale of any millionaire found stabbed in any library, locked or otherwise. And far more important, too especially if you live in California.

    ISAAC ASIMOV
    17 April 1974