I remember listening to a podcast where a psychiatrist was talking about something similar to what you are describing.
Take something a person could desire like wanting to learn how to play the piano, for example. Often times, what people desire is not the learning part but the end result. People are fantasizing about drilling scales and chords for days on end. People are more likely to fantasize about creating music, playing music for the enjoyment of others, the praise, etc.. So, people tend to fizzle out when the reality does not meet the expectation.
The brain tends to fantasize about all the good that something can bring, but the brain also tends to vastly underestimate the work required to achieve said goal.
I think for programming it is mostly idea of "easy job" like sit behind the keyboard and get paid loads of money, as soon it turns out it is not sitting but quite exhausting mental gymnastics they are out.
I also heard that loads of times: "get a real job" (maybe not exactly in those words but hey, that was the gist) then I got people who would try out some basic things for an hour or two feeling mentally exhausted.
Not saying they were not capable or stupid - just that they underestimate how much taxing it would be for them to do something like programming for couple hours.
It is easy for me but I am doing it for 10+ years professionally and good couple years while I was a kid.
Take something a person could desire like wanting to learn how to play the piano, for example. Often times, what people desire is not the learning part but the end result. People are fantasizing about drilling scales and chords for days on end. People are more likely to fantasize about creating music, playing music for the enjoyment of others, the praise, etc.. So, people tend to fizzle out when the reality does not meet the expectation.
The brain tends to fantasize about all the good that something can bring, but the brain also tends to vastly underestimate the work required to achieve said goal.