After turning off the shower this morning, I noticed a rather loud
buzzing/moaning/vibrating noise coming from the pipes when I turned off
the shower and faucet.

Google for "water hammer". That is likely what you have.