What’s the difference between AirPods’ Noise Cancellation and Adaptive Audio modes?

Modern AirPods offer several audio modes, and noise cancellation isn’t always the best option.