I'd say it is vulgar, but also in common use. Go with "pain in the neck" or "pain in the behind".
In Ireland you could say "pain in the áras", ie. replacing the vulgar word with an innocent Gaelic word (áras=hall), and another Australianism is "pain in the clacker".