Auto orient flipping object on the last keyframe

Hi all,

I'm trying to simply make my ship follow a path set out by a shape layer using auto-orient. However, when I try to add a new position keyframe on my ship after the path ends to hold the ship between the two keyframes, it starts drifting and messes up the auto-orient rotation. I tried to toggle hold the first of the two keyframes and even though the drift stops, the ship rotates -90 degree at the last keyframe. I have attached videos of what's happening for better context.

I basically want to keep on updating the path on run-time instead of drawing it out all at once on a shape layer but the auto-orient messes up if I do that.

After Effects 2020 version 17.5.0 (Build 40)

Windows 11 Home 22H2