As far as I know and can tell, fire arrows cause an increased moral penalty but have a much lower accuracy (thus inflicting fewer losses).

I personally use fire arrows only in siege defenses or to break wavering units in the field; otherwise I stick to standard ammunition.