Cloud Atlas (released 6 years after Moonfall was released as a book) also has a story with the earth being destroyed by mans attempt to harness the moon for energy (and also has a bad film adoption).

Moonfall is the first book I know of that used the concept, but it seems like humans have been fascinated with man or god(s) manipulating the moon for a very very long time, the oldest case I can think of is from the Quran (https://en.wikipedia.org/wiki/Splitting_of_the_Moon), so we've been fixated on the idea for a long time.

Maybe there are more cases and I will read about them in the comments here.