Fire arrows are definately most effective against Elephants. I also use them to encourage the enemy to flee. Firing flamming arrows at enemy troops wont really affect them all that much, however fire at the enemy when its engaged and tired and they`ll start to panic. Fire arrows have helped me tip the scales in an even slugfest in many a Multiplayer battle.