[craftyguy]

The Earth and Moon system orbit the Sun, but the Moon is very much in orbit around the Earth.

A more likely scenario is that the Earth's orbit will move outwards as the Sun expands, since stars in the red giant phase(s) lose a lot of mass. It's plausible that the Earth/Moon will not be destroyed, physically. But in that case all life would have been obliterated due to the immense temperatures associated with having the surface of the Sun within a few million miles (or less) of Earth.