Is muscle memory real

Yes, but the memory is not in the muscles themselves, it is in the nervous system.

A more correct name for it might be "learned reflexes" because this form of memory/learning happens well below the level of consciousness, near the level of the reflexes.