The Y loc curve will be directly towards and away from the camera view, so that ‘wonky’ vertical motion path is because you have the z loc cycling and the x loc ONLY looping once. (the motion paths will show you from frame 1-250 if you leave it at the default settings.
Don’t give up – it will all start making sense really soon.