I'd think that even if turned off, Airpods and similar devices act as decent earplugs in a pinch.
I still wear real ear protection, but for the odd cut, or for any other day to day situation with loud noises the AirPods do a good job.
Would you be willing to give a personal experience? Have you tried transparent mode in windy conditions?