The moon is slowly creeping away from Earth, but will we actually lose the moon before the sun turns into a red giant and destroys us both?