It can, in theory.
Theory is this nice little town in Wyoming. Nobody lives in Theory.
In Practice, an overcrowded little hamlet just to the southwest of Theory, maybe yes, and maybe no. Maybe yes and no.
Asking for the Moon, kind of literally, is also asking for the GM to find ways for the spell to screw up, likely so that you sort of get what you want, but in ways that don't really help you in the long run.
and this one is so simple to screw up for you. Like...
I Wish the moon would eclipse the sun!
Sure - it will do so naturally, one thousand, four hundred and thirty two years from now. Wish granted.
Um, okay, that was cheap of you. So... I Wish the moon would eclipse the sun... Today!
Sure. You are moved one thousand, four hundred, and thirty two years into the future. There is now an eclipse for you today. Wish granted.
And so on.