I have both manual and auto. For moon pics, I generally use manual since the contrast is too low to get the auto to work at its best. It seems overwhelmed by the brightness against the black background.
Sometimes I can get it to work by focusing on just the edge of the sphere against the black background.