A friend of mine has her labret pierced and she is a registered nurse. I thought for sure that her supervisors as professional healthcare workers would oppose, but from what I understand, she has never had an issue or any repercussions. I don’t think that the intense stigma concerning visible piercings is as present as it was only a few years ago. However, it’s really dependent on how lenient your superior is, the nature of a job, and where you are located in the world.
I also think it is completely ridiculous to refuse to remove your piercings for a job that prohibits them. Perhaps when you become the president of your own company, you can fully enforce that decision, yet as a subordinate it is part of your job duty to adhere to the required dress code. This should be a brainless internal debate, pay your bills or leave an extra hole in your face. This isn’t rocket surgery.