[The Barrow-Wight]

I don't believe the Red Arrow was symbolic in any way. It was simply the 'code' for letting Rohan know their aid was needed. A black arrow or a green spear would have been equally as effective. It just happened that Gondor and Rohan chose a red arrow.