I have a clay bottom half acre pond in Texas. I use THIS 35W solar pump. It has a hose on the back end that I attached to a tree so the water falls out over the water for good aeration.

I bought it May 2021. In fact, there’s a drought here and I checked it today and the water line had fallen below the pump so it wasn’t running. I immediately assumed it had burned the pump up and quickly ordered a second. I cleaned it off and resubmerged it and it started working again. Probably not the fanciest solar pump/aerator but definitely best value. Made it through 2 Texas summers and a big freeze in the winter.