Arrows are about focussing a player more towards one mentality - red makes them focus more on offensive role (but don't neglect completely their defensive duties), blue more on defensive role .

It helps me to think of the Mentality setting in Orders as a Team or Global setting and arrows as an additional tweak at an individual player level.

Arrows also seem to cause more condition loss.