What is the weight limit of an average shower head pipe?
It is hard to say without opening the wall you may have a metal pipe coming out of the wall and PVC or CPVC, copper or Galvanized pipe. With galvanized pipe it might be strong enough if the pipe is strapped to a stud but you would be taking a chance.