I was about to write that I have been unsuccessful at making it face the exact direction of the destination, as per my previous post about the offset issue.
I had almost given up, then I noticed that I was setting the End Rotation once instead of setting it inside the loop so it would get properly set for each point.
Well, success, now it is pointing at the exact destination and it can point even behind the ship, albeit at a safe distance to not break the curvature too much.
I have not mastered gif making, so a single shot will do.
Thanks for all the help Clockworkocean, could not have done this without you!
I do hope that in the near future they add some curvature control to the characterMovement component, having fiddle with that for what seems forever, making something curve smoothly and consistently just became a pain. It is very obviously made for humanoids.