In the private sector, you’re usually done if your employer finds questionable content in your social media. The topic is irrelevant, could be political, sexual, humor-related, whatever.
All it takes is for somebody to complain.
Unless you work in an “out there” industry like entertainment...