I agree that flowing water can make noise. I guess you’re saying the dynamic pressure is higher when the pump is moving water ? I agree with that.
The OP should try to recreate the noise while the house is static, no flow.
The OP should try to recreate the noise while the house is static, no flow.