Try to use heavy cavalry in a charge against the back of a elite pike phalanx. Then try the same with elephants. You will see the difference.

I'm currently playing Makedon and I'm missing elephants a little bit.