I use them to throw the enemy lines into disarray or when I need to get out of a stalemate. Personally I think they are most effective as psychological weapons. I mean, they don't kill as much as one would think, I simply let them run around, sowing terror in the enemy ranks, they are most effective this way, just make sure they never stop. Keep those elephants moving.