I don't think that being fascinated by extremely low-probability but dramatic possibilities has anything to do with autism. As you imply, people in general tend to do it, though being terrified about airplane crashes might be a better example.

I'd come up with an evolutionary explanation, but a meteor would probably fall on my head if I did that.