Pipe comprising a metallocene-catalyzed polyethylene resin