The impact of red arrows can't truly be known unless Nordeus actually tells us what their impact is.
Regarding me, I treat arrows with the assumption of red arrows mean my players plays one position up while we have possession and blue arrow mean they play one position back when we're defending. I've never placed red arrows on my strikers!!!