You cannot break a well-defended enemy with just archer waves. You built a defensive army, and then compain when it lost on offense. You needed tons of scouts for scout-bombing and/or clearing waves of warriors to set up cavalry attacks.

You are right. Archers on the attack get slaughtered by archers behind walls. You just proved it.