Water is fairly viscous, and when you try to pull through too fast you completely change regime due to cavitation.
In comparison, from my days studying aerodynamics for RC soaring, air has a wider range of "viscosities" (represented by the Reynolds number) depending on the scale of your aeroplane and the speeds you intend to go through the atmosphere. The aerodynamic ideal or what count as useful tricks (winglets, dimples) can be fairly different for a a golf ball compared to a RC airplane compared to a commercial jet compared to a fighter jet...
Water is also largely incompressible. The fluid dynamics are just too dissimilar to air to carry over simplistic assumptions.
Asking as a complete neophyte - how does this reconcile with modern war planes being inherently unstable as far they flight dynamics go, without their enormous thrust capabilities? I’m just curious, I know nothing about the subject, but it seems that the solution we came up with is thrust, baby.