The article says that the Federal government provides no protection between State and County or City. Texas specifically may have law prohibiting this new law, but that’s only because the new law is too broad and too vague. That might not stop other states from implementing the law successfully, however.
It won’t go to SCOTUS, it’s all at the state level. Unless someone comes up with a US constitutional angle, or something.