Nice try, but no banana, Cranberry, nor the Straight Dope guy.
Nursery Rhymes tend to be obscure, but they also tend to be either
a) Rude, or
b) Political.
This one, you will be glad to hear, is political. The original “Humpty Dumpty” was a large cannon, or perhaps mortar, in use in the English Civil War.
It was last used somewhere in the West Country (Somerset, Devon or Cornwall) where Parlimentarian forces concentrated their cannon fire on the wall supporting it. When the wall gave way, the cannon was irrepparably damaged. Hence “All the King’s Horses…” etc. That was the last advantage in ordinance that the Monarchy’s side had - and their advantage in cavalry was weakening with Cromwell’s “New Model Army”. In fact the end of Humpty Dumpty was the beginning of the End for the Monarchical forces.
This link sort of bears me out, but provides other possibilities.
The Tourist Board at Colchester deny the story - but I first heard it about a different castle. Can’t remember the name, but I recall it as West Country. But it sounds realistic as a memorable jibe against the opposition - much like the yankee song “Goober Peas”.