The transformer is significantly undersized. You need 10A - 15A vs 2.7A or 3.0A. The number of Amps the pump draws increases under load (higher pressure). You need a much higher rated transformer.
Ive used this one with that pump with great success. Just put 2 wire nuts on the 2nd output that I wasn't using.
inShareplus 24V 400W LED Power Supply, IP67 Rainproof Waterproof Outdoor Driver,AC 90-140V to DC 24V Low Voltage Transformer, Adapter Converter for Outdoor Use https://a.co/d/c0M8fVo