Lance-armed cavalry are useless in melee, because the lance has a long preparation time. Pit two equal units against each other, and have one switch to swords in melee, and you'll see them butcher the lance-armed unit. You can even see it in the animations, the lance doesn't strike as often as the sword. Or spear for that matter.