The HP2 Survey. IV. The Pipe nebula: Effective dust temperatures in dense cores