There is no doubt you'll notice the difference but you will quickly adapt. The biggest difference in my experience is in the low drumming frequencies. You'll still hear what you need to.
I might be wrong but I suspect the aviation ANR headsets have a different noise cancellation profile to an audio ANR.