What I do not get is that while Air compressors have lots of issues because they are mainly diaphragm type pumps, water pump that are built on prop / vane technology have long service life, so why not create aspirated pumps? The introduction of air to a water pump is very easy and produces a hefty amount of aeration.

This way the pump could remain on shore with the suction line in the water, and the air mixed on the suction with the discharge located wherever you want to place it (provided you are not TOO deep and too long a run for proper discharge pressure).

Nice part about aspirating too is that you do NOT need a trouble prone diffuser in the pond.