Based on this tutorial - https://www.youtube.com/watch?v=UeVQ4VU7cKc
There is a comment from some guy
This wasn't working for me in UE5.4. The modified animation worked in the editor but not in game. Someone on the forums said you need to goto the skeleton tab and update the changed bones to Animation Scaled. Worked for me after that.
It is same problem.