And the sad grandeur of the last TSR2 (look it up) all alone at the back of a hanger with its wings off at Cranfield doesn’t make you sad you should not be working in technology not even on some little iphone fart app.
And that's fine, now we have someone who's doing something else and better informed to boot.
I'd venture this "problem" is neither a problem nor is it unique to our field. People think making video games is sexy until they see the innards of a game studio. People think making movies is sexy until they actually start doing it. People think being a musician is sexy until they've dealt with labels, marketing, and the royalty system.
So on and so forth.
Nothing executed at a high level is actually that sexy, but that's okay, because it's still sexy to the people who are doing it. Tons of rocket scientists, software engineers, automotive engineers, movie directors, and musicians wake up every day and can't wait to do the myriad of supposedly boring things they find sexy.