Fire arrows are less deadly and/or less accurate than normal arrows, but their morale penalty makes them usefull against units that can run amok: elephants and scythed chariots (NOT against ordinary chariots). I suppose you can also use them to tip a wavering unit into a rout, but for killing power normal arrows are better.