In a few billion years, the Earth-moon gravitational tug-o-war could end in tears.