Only the most heavily armored cavalry units has good staying power in melee, but this is effective only with very lightly armed units like skirmishers, because even using swords most cavalry has low attack values and combined with their limited number they just can't kill much in melee as they can with a charge