There are 3 ways to make a piezo really loud.
1: A fine tuned cavity, e.g. a custom made piezo disk, and to operate at its (optimum) resonant frequency then placed in a tuned cavity that reinforces the frequency, Cicadas have been doing it for years.
2: Drive the piezo with high voltage, 20V to 50V.
You will need a piezo element that is designed/capable of handling high voltages, many will take 20V to 30V, the smaller ones usually don't.
3: Use an Inductor (coil) in parallel with the piezo element. When an inductors magnetic field collapses it can produce up to 10 X the input voltage, but in reverse.
This high voltage is pushed back into the piezo (which is a capacitor) the piezo then discharges back into the inductor and so on.
This is called a Tank Circuit, the back and forth voltage dies away within a few cycles due to electrical losses. If pulsed from an open collector transistor the output from the piezo can be several times the output from a transistor only.
Many small beeps from electronic devices e.g. watches, calculators, toys are in fact a single pulse, the piezo/inductor do the rest.
Finding an inductor that is exactly tuned to the piezo element is the hard part.
You really need a good LCR Meter and calculator if you want to make your own.
Usually involves a couple of hunderd turns of very fine wire on a ferrite bobbin.