UE5 bug when trimming animation?

FINALLY I have the answer.

To fix this issue you need to open up your anim BP, go to your state machine, locate the animation that is hooked into the current pose, select the animation, then un-check ‘Loop’

This error is caused by the default loop setting which returns the animation back to starting position and runs at odd or incomplete times if you trim the frames or change the rate scale of the animation.