Keep the collision sphere as the physics root, but don’t attach the FX to it. Create a separate scene component or arrow component that does not inherit rotation, update its world location every tick to match the ball, and drive the FX direction from the ball’s velocity. Also make sure the Niagara or particle system is set to world space so it ignores the ball’s spin. This way the ball can rotate freely while the trail stays aligned to movement only.
How do I add a component that is not attached to the root? Does it have to be in the bottom of the components list below that dividing line? I’m not sure how to do that.