The phrase ‘over the moon’ means ‘very happy’, ‘delighted’. It seems to have originated in Ireland in the early 18th century.