Well written article, but unfortunately it's almost completely inaccurate... Or at the very least, irrelevant to what anyone is upset about. NOBODY is complaining about the new text tone, because it CAN be changed back. That's the one thing you were correct on. The old text tone was Note, not Tri-Tone as you said. The new text tone is Droplet (I think... I already changed it back to Note), not Rebound as you said. The old notification sound (which is 100% the issue everyone is complaining about, and 0% the topic of your article) was Tri-Tone, and the new notification sound is Rebound. And it CANNOT be changed.
My upgrade to iOS 17 was via the beta program, so these changes occurred for me a week prior to the release of iOS 17, when I got the iOS 17 RC. I assume everyone else's text sound changed along with their notification sound changing when they upgraded to iOS 17, but since it oddly still showed Note as the default in settings, I wasn't sure about that.