If it's that noisy the eccentric cam has broken, or the
piston is so worn that there is very little travel. This means
when there is no demand you have pressure, open the trigger
and insufficient flow to maintain any pressure.
Replacement bearings are about £25.
I was going to suggest starvation to the pump, but
the noise is the give away.