Obviously you are meant to place trebuchets along the route and be shot from one to the next. With exact timing you could even use another trebuchet to slow you down each time.
M1 Abrams: Requires an advanced economy plus an army of General Dynamics contractors for maintenance
Trebuchet: Can be completely repaired by one hammer-wielding villager
Plus, I assume that tanks count as a cavalry archer unit, which means any old monk can start converting them. Meanwhile trebuchets can't be converted until your enemy researches redemption at the monastery.
in AOEIII artillery are siege weapons so I think tanks would count as that, I remember getting my onagers converted in AOE but I don't remember if that's a thing in AOEII
In the older civ games, unit stacking was a thing. The maintenance would be costly and you might break the game with some kind of unit cap, but I think the trebuchets would eventually win.
I play freeciv which is civ 3.5. Unit stacking is a thing and a stack of whatever can defeat whatever
Incidentally I like to give competing civilizations railway technology so when I attack them I can easily overrun all their big cities in a single turn