If it could work marginally, I suspect this would require at least a pair of giant subwoofers right next to the fan, but then I wouldn't expect it work very effectively.

Instead, it's probably a better idea to not create the noise in the first place.

PS: Typed while wearing a pair of fairly tattered Bose QC45 1st gen because I'm intent on repairing perpetually rather than $$$ replacement.