You’re only aware of narcosis when it’s significant enough to notice.
Do a chamber dive to 40m/130ft and you’ll be giggling like schoolgirls. Do any basic task and you’ll be far more impaired than you realise. Three or four pints impaired.
When you’re pissed you notice these changes in personality (loud, gregarious, uninhibited, etc. — which is why we drink!). You notice the physiological changes (leaning on the bar, balance, coordination, etc.) and the psychological changes (distraction, lack of focus, need to dad dance, etc.)
Something is odd about being wet. It’s like your senses are numbed, mainly because you’re not using balance, here’s little to hear, limited sight, wearing thick exposure protection (attenuating touch sensitivity), not communicating nor socially interacting (thus not using higher functions which give feedback as to your impaired behaviour). But you are impaired, especially for higher level skills of logical reasoning, deduction, memory, etc.
As you dive much deeper on air results in you becoming more and more impaired, eventually being unable to perform basic reasoning. Even becoming unaware of serious life threatening situations — almost paralysed (have read many accounts of divers rescuing other divers and once shallower they wake up.
Helium is your friend.