The spear is there for the charge bonus (all the momentum of the charge gets placed in that shiny, sharp spear tip ) as far as cavalry goes, but yes, close combat usually goes better with secondary weapons, regardless of circumstances. Cataphracts and possibly egyptian cavarly with axes have armor piercing bonuses attached to the secondary attack.