The name came from a 1968 quip by The Who’s drummer Keith Moon. During a U.S. tour with The New Yardbirds (Jimmy Page’s post-Yardbirds group), Moon joked the project would “go down like a lead zeppelin” (i.e., a lead balloon—a disaster).
Page remembered it. Manager Peter Grant suggested dropping the ‘a’ in “lead” to avoid mispronunciation (“leed” vs “led”). Led Zeppelin was born—symbolizing heavy (lead) yet soaring (zeppelin), perfectly capturing their sound.