Unrealistic desire or ambition. (Compare to Fairy tale ending,Castles in the sky, Flight of fancy or Look at the world through rose-colored glasses.)
“He has his heart set on being a race car driver, but it’s just pie int the sky since his vision is so poor.”