I have heard that for non-autistic people anyway, tuning out noise is a skill that your brain has to learn, and that's why the health organizations recommend it limiting your time on noise cancelling headphones.
Is it different for people with autism?
Yes. The inability to filter out noise is a common experience with autism. This is one of the reasons people might wear noise cancelling headphones.
In a noisy environment, many autistic people say it is difficult to hear what’s being said. Background noises can create overwhelming listening difficulties. Conversations can become a jumble of words (as shown in the image below, created by the authors).
I personally use ear plugs or head phones that are not powered on to filter out noises so I can focus on conversation.