Pipe dream has 2 different meanings across 1 category:
Noun
a fantastic but vain hope (from fantasies induced by the opium pipe)
"I have this pipe dream about being emperor of the universe"
A plan, desire, or idea that will not likely work; a near impossibility.