Using Animated Root Motion, but the orientation is actually different

The character root is oriented with Z+ to the sky and Y+ to the front.

The character animation moves in the Z+ (sky) direction and then moves in the Y+ (forward) direction.

I want to use RootMotion to move the character.

However, when I play the animation montage in-game, the character moves in the X+ (sideways) direction and then moves in the Y+ (forward) direction.

Just to be on the safe side, I create an animation that moves the character in the X+, X- (sideways) direction and when I play the montage in-game, it moves in the Z+, Z- (sky) direction.

Why is this happening and what am I missing?