Ballroom dancing you learn by counting 1-2-3-4 at some point that stops and the feeling for the music takes over.
Learning traditional martial arts you learn action and response. At some point you need to stop thinking and start reacting instinctively.
Flying is not that unique that landings are this mysterious art.
No, not at all. What your describing is complacency. The most common quote from any performer is "the day that I'm not terrified before going on stage will be the day I need to pack in". Professional performers and without doubt also fighters practice, practice and practice throughout their careers and take nothing for granted. What you appear to be confusing is the benefit of adrenaline when it is focused to the task. Performers learn to use this heightened state to their benefit but it should not be used as a reason to switch off. No performer does that.
A root cause of many accidents is associated with complacency. It is no surprise that very few accidents involve ab initio pilots.