Given the breathless tone and the curious turns of phrase, I strongly suspect the author has no background in sound, acoustics, science, or journalism.
Particularly with fan noise, there’s often one or two stand-out annoying harmonics while the wide-band noise is less offensive.
And I think the point is that this blocks out only certain frequencies, without being a massive structure (you can easily make a serpentine acoustic notch filter but it's gonna be huge)
https://www.bu.edu/research/files/2019/02/acoustic-metamater...
Certainly interesting, but the applications of that would be somewhat niche.
To be specific, there are not that many scenarios where a solid wall won't do, but a honeycomb-like barrier is OK. Aesthetics are important, but musicians in a studio couldn't care less about how stuff looks as long as it works (and so do your musicians' neighbors).
One good application, as others have mentioned, is putting that thing around a fan, to minimize noise (a solid barrier defeats the purpose of a fan). I wonder what else would be a killer feature application of this kind of structure.
For more info, see https://simple.wikipedia.org/wiki/Decibel (which is much more approachable than https://en.wikipedia.org/wiki/Decibel).