I have noise canceling headsets in my airplane. The noise in a plane is probably very similar to that on a motorcycle with wind, engine, exhaust and propeller noises that all get canceled out pretty well.
The first time I used the noise canceling headset in the plane I was able to hear a bad bearing in the nosewheel. This noise could not be heard before.
The biggest issue is that you need a pretty good seal around the ear cups. Even a small eyeglass arm can significantly reduce the performance of the noise canceling. This would probably be difficult to achieve inside a helmet, but I could be wrong.