Failed. (lead is a heavy metal) Imagine a balloon but instead of filled with air, it’s filled with lead, it would not float but fall with a thud to the ground, so this phrase implies that an idea fell flat with its audience.  (Compare to Dud.)

“When I asked mom if I could stay over night at my girlfriend’s house, the idea went over like a lead balloon with her.”