Making sequencer work with root motion animations in UE 5.4

This post also describes similar issue: How to properly use rootmotion to move a character using the sequencer?