Alright I got it. I was able to fix the issue by adding the root bone again on the Mixamo animations using the Blender addon but this time by turning off ‘Transfer Rotation’ and ‘Apply Rotation’ checkbox in the addon settings.
Then I reimported the animations in UE and retargeted again and it worked!!
