Meaning of the word "pipe dream" in English

What does "pipe dream" mean in English? Explore the meaning, pronunciation, and specific usage of this word with Lingoland.