Responding late, but since this is top search result it might be of help:
i found that the issue was the Movie Render processes run the physics at a lower frame rate and that breaks it. You need to enable physics substepping in project settings and set the values such that they’ll play well with yoiur output framerate. This helps the engine fill in physics between the frames so it doesnt break. (fixed my issue on unreal 5.5.4)