One thing that the new Dune film captures extremely well is the idea that the primary small-capacity air transportation mode on Arrakis is travel by ornithopter. The choice of flapping wings as a lift/propulsion mechanism can be in-fictional-universe justified by the idea that jet turbines probably won't do well in an atmosphere with lots of suspended dust and sand, especially on take-off and landing. Still, I think Frank Herbert decided on ornithopters because it just sounded cool.
The actual physics and engineering of flight via flapping wings is complicated. This site is a good place to do some reading. The basic idea is not hard to explain. To get net lift, in the cyclical flapping motion of a wing, somehow the drag force pushing downward on the wing during the upstroke has to be more than balanced by the flux of momentum pushed downward on the wing's downstroke. To do this, the wing's geometry can't be unchanging during the flapping. The asymmetry between up and down strokes is achieved through the tilting (at the wing base and along the wing) and flexing of the wing during the flapping motion.
The ornithopters in the new movie have wings on the order of 10 m long, and wing motions that look like those of a dragonfly, and the wings are able to flap up and down and an apparent frequency of a couple of hundred hertz (!). If you try to run some numbers on the torque, power, and material strength/weight that would be required to do this, you can see pretty quickly why this has not worked too well yet as a strategy on earth. (As batteries, motor technology, and light materials continue to improve, perhaps ornithopters will become more than a fun hobby.)
This issue - that cool gadgets in sci-fi or superhero movies would need apparently unachievable power densities at low masses - is common (see, e.g., Tony Stark's 3 GW arc reactor that fits in your hand, weighs a few pounds, and somehow doesn't have to radiate GW of waste heat), and that's ok; the stories are not meant to be too realistic. Still, the ornithopter fulfills its most important purpose in the movie: It looks awesome.