There are two basic principles at work here - surface tension and gas exchange and then oxygen (and other gases) saturation levels in water.
Still water naturally has a surface tension which inhibits the free exchange of gasses between the water and the air. Rippling the surface braks this tension. How much gas can be exchanged between the water is then a function of surface area. That is why similar gallon/liter size tanks but in different configurations have differing maximal excgange rates. long tanks have a greater surface area than tall ones.
Finally, the move violently roiled the surface is, the more oxygen it can have added, to a point. The Rio Xingu in Brazil is home to many fish in the hobby. Its water can get very warm (over 86F/30C) and what allows many fish to survive are the series of violent rapids which churn the water which increases the area of water expose to the air and works to bring in even more O.
In our tanks there is a limit to how much we can do before we either blow the water and/or the fish out of the tank. But for most of us just having decent surface movement does the trick. Air bubbling does the most good not by adding any O to a tank, but rather by the bubbles roiling the surface to promote gas exchange.