in a 1 on 1 with fresh units cavalry will not win against infantry when attacking head on. It is only effective when attacking weakened or wavering units, and/or in combination with a flank/backside attack.