For folks thinking about this post and wanting two hard SF takes on the subject, Neal Stephenson and Stephen Baxter are two great choices. Seveneves deals with the destruction of the Moon, while Flood is, well, you can figure that one out. :-)
Both well worth reading on their own, anyway.