Quick 1am thoughts (may not be coherent or useful):
How are you measuring the resonance? It will probably drop loads when clamped and in contact with water.
You may be hitting a resonance of something else inside the system. Waterwaves in the cavity?
While you will get the largest piezo motion at resonance, but the water motion through the pump may be much lower as it cannot react fast enough.