Well if the cavalry does not charge they will loose against close to anything :D

Elephants do seem to make a bigger punch but regular cavalry is just sooo much more reliable and will not run amok into your troops ;) Personally I like the starting elephants of some factions, but generally I prefer good ole Cavalry, afterall you don't have to charge the phalanx fromt he front^^.