I have fallen into the (questionable) habit of sleeping with Airpods. I used to wake up with my mind racing and not be able to fall back asleep. The Airpods helped distract and sedate my midnight thoughts such that I would fall back asleep much quicker than without. I've progressively shifted towards falling asleep listening to the droll of engaging non-fiction, but keep them in my ears in noise canceling mode with no media for the remainder of my night.
Again, not medical advice, just anectdotal experience..
Edit: this is entirely due to the 'Stop playing when falling asleep' function of iOS 26, which I loathe. But this feature barely make it worthwhile.
I was wondering how good their noise cancelation would be for night-time sleeping, how effective would you say it is?