In the end it's still infantry that gets rid of enemy infantry and generals, large massed infantry that do not rout and demoralise the enemy. Cavalry takes out cavalry and missiles because enemy cav and missiles are bad for your infantry's health. Missiles weaken enemy infantry so that your infantry have an easier time chopping them up. Infantry free up your cavalry, allowing them to run wherever they want and rout whoever they want.