I have Bose and like them a lot. They’ll probably do exactly what you want, however, noise cancelling is not all noise cancelling. Mostly lower frequencies. It makes things quiet but if you’re in a loud environment with lots of mid to high frequency like talking, they’re not gonna help much. Haven’t used the Sony’s for a long time but I think the noice cancelling is the same.
I know you want to use them for sleep, but since these are big headphones already, I’d recommend a pair of noise protection earmuffs and use earbuds or shove some speakers from another set of headphones in there. This will be the best noise cancelling but least comfortable.