I feel this way about a lot of topics. Concepts are extremely fun to explore and easy to get enamoured with. But actually doing real work in some topics can feel totally disconnected.

You might love mechanical engineering and machines so you get into machining parts. By hand it is exactly what you thought, but once you hit CNC you're back to a desk job, spending most of your time in CAD software not even touching the machine.