It can be interesting for generating unfamiliar colours, but that's all. It's certainly not a deep key to harmonic theory.
And it ignores the fact that scales don't necessarily repeat at the octave, scale steps don't have to be equal, and there can be any number of steps in a scale.
Yes the point of things like this is to help understand the framework that underlies (edit: most western) music. There's actually a lot of structure to western music that is obfuscated by the completely bonkers terminology. I find articles like this very intersting and useful, and there's no way you'll catch me listeneing to stockhausen.
For example the explanation of modes vs scales in this article is the clearest I've ever seen.
That is, there are cultures that formalize or structure their music differently, and there are properties of music that are outside of these models. There are even many popular or niche songs that work against some aspects of this structure.
And all this is not about the ineffability of art, it is simply about not confusing the map for the territory. Many people who wax poetic about the mathematical properties of music, and start deep theories about the human brain and our enjoyment of music from there, tend to forget that the mathematics are describing a particular formal system that some choose to use when making music; they are not mathematical properties of anything that a human being would recognize as pleasant music.
I dont think thats true, especially on HN. We're perfectly capable of being interested in the mathy bits without losing sight of the arty bits
e.g. the OP who wrote that very analytical piece about every possible scale composes music like this https://ianring.bandcamp.com