I read somewhere that HumptyDumpty represented such a siege tower being overthrown by defenders.

I had it a bit garbled

t is believed that Humpty Dumpty was the name given to a narrow-barreled squat cannon mounted on top of
Saint Mary's Church, near the Balkerne Gate and Jumbo water tower, as part of the town's defences. Humpty
Dumpty received a direct hit by a cannon ball fired from Parliamentarian forces, lead by Sir Thomas Fairfax.
He was attempting to breach the town's defences in pursuit of its Royalist captors, lead by Sir Charles Lucas
and Sir George Lisle.

Falling to the ground, along with a large section of the church's tower, Humpty Dumpty lay in pieces