I'd like to say, I have a tongue piercing. And it has not affected my ability to play flute. I could flutter tongue before I got the piercing. And with some practice, I could flutter tongue again. It hasn't changed my pitch at all. And I am very disappointed in the low amount of knowledge portrayed by some people on here. Do actual research before you go stating facts that aren't true.
Get your piercing. And if it doesn't work out, take it out. It's that simple.