Is there any way to use "Rotation Follows Velocity" in Multiplayer Game?

You state that the flight path is fine but it just faces the wrong way…
I assume that your arrow has a Blueprint? Go into the Arrows Blueprint and in Viewport try rotating the arrow in the Transform setup