Piezo buzzer giving faint clicks instead of loud buzz
As I suspected the buzzer you linked to does not have a built-in oscillator. It must be externally driven with a square wave per the datasheet. You can do this by switching the GPIO pin on and off repeatedly at the frequency you want your buzzer to "buzz" at.