The story
Presumably from go over (“to be received”), used as if literally (“to travel above”): a lead balloon would not travel well through the air.
Etymology from Wiktionary, CC BY-SA 4.0.
go over like a lead balloon
Today it means: To fail to gain acceptance: to be received poorly. Full definition →