Water compresses, just not enough to be useful for domestic water supply systems.Ok.
Water doesn’t compress.
You have to have an air chamber or some bladder to have any reasonable pressure stability.
If you just have pipe and water and pump as soon as your pump comes on the pressure hits past peak.
OR. You can pump to an elevated reservoir or tank and then hydrostatic head supplies the pressure. That’s the reason you have water towers.
It sounds like your bladder is flat or the screen on your pump may be stopped up (if it has one)
When your pump comes on the bladder will compress to 1/2 it’s empty volume when you double the pressure.
If it holds two gallons and is pressured to 16 psi it will hold one gallon at 32 psi 1/2 gallon at 64 psi, etc.
I’m sure you will hear otherwise but water doesn’t compress. Try to compress it goes wrong quickly.
In order to obtain 50 psi using head pressure, the water tower would have to elevate the water 115 feet... and that's before accounting for friction loss.