Via Wikipedia: “Caroline, No” by the Beach Boys was originally written as “Carol, I Know,” but Brian Wilson misheard it and they ended up going with the present title because it’s cooler.
This is neat because the accidental mishearing of the lyrics ended up giving the song more poignancy; “Caroline, No” is a weirder construction, and seems to convey more emotion. But it also shows that lunatic music geniuses also have the universal experience of mishearing lyrics: “Here we are now, in containers,” “Scuse me, while I kiss this guy,” etc.