Why is my AirPods Pro Gen 2 noice cancellation not blocking all sounds?

Hey, I bought AirPods Pro Gen 2 yesterday, mainly because I read online that the noise cancellation is insanely good. When I activate noise cancellation, it effectively filters out the sound of a running dishwasher. However, I can still clearly hear my spouse walking or placing a mug down in another room. Even when I walk around my home in socks, I can hear my footsteps.

Additionally, there isn't a significant difference between transparency mode and noise cancellation mode. While the dishwasher noise is reduced in noise cancellation mode, other everyday sounds remain unchanged. I'm using the AirPods with an iPhone 13.

When I browse the internet, I see that many people have this same issue. Is my AirPods malfunctioning, or is the noise cancellation just complete garbage?

[Re-Titled by Moderator]