Its an inherent issue with the UX of UE5 and UEFN. They don’t have the “easiest” solution enabled by default, and the alternative (quaternion interpolation) is an obscure setting in the edit settings of that transform that causes bugs to happen (interpolation snapping mainly and removing keyframe edits) but helps fix your issue.
This fixes it, but you may encounter some other weirdness enabling it