I've actually used AirPods Pro (and my girlfriend used her Bose QC35 IIs) to fall asleep in a hotel room with a very thin wall and a loud conversation in the next room over. If you toss and turn or insist on sleeping on your side, they might not work, but if you just sleep on your back or front there shouldn't be much of an issue.