I think the initial idea was giving cavalry a spear type weapon for charges which they discard in favor of a melee weapon once the charging is done. However, for some reason or another it never quite worked as intended, the AI never uses the secondary cavalry weapon, to the best of my knowledge.