I don't want to argue with your numbers, but it has been my experience that archers can be better than muskets in real battles.

My example is Totomi, which is a musket-friendly map if ever there was one. I am aware that many people pick honour 0 or honour 1 muskets, knowing that honour does not affect their accuracy/attack strength.

If I pick honour 3 archers, I will rout the muskets, every time. And when the battle becomes a melee, my archers can still be useful, where muskets can not.