When I discovered the pronunciation of Houston, TX and Houston, NY... my mind was blown

This is true, but if the goal is to be understood, it's in the speaker's best interest to pronounce words in a way they'll best be understood. So I think even if the language itself lacks formal rules, we as a society of communicators should align on some loose set of rules.