Note the helicopter peforms work on the air, accelerating it downwards (and circularly). This is a different case than the fluid in a pipe case, since the pipe peforms no work on the fluid.
The pipe example is using an ideal non-compressable fluid. In this situation, the amount of mass flowing across any cross section of the pipe is constant. There's some type of force - pressure being applied to cause the fluid to flow in the first place. Since the mass flowing across any cross section is constant, and the fluid is not compressable, the fluid has to be traveling faster in the thinner part of the pipe for the mass flow to equal the mass flow of the fluid in the thicker part of the pipe. In order for the fluid to be traveling faster, it has to accelerate as it transitions from the thicker part to the thinner part. The only reason it would accelerate is due to a pressure differential, so therefore the pressure in the thinner part of the tube must be lower than the pressure in the thicker part.
Even in the case of a realistic fluid, the smaller tube section has a lower pressure. There are syphons that you connect to a faucet, that rely on the venturi effect, using a flow of water through a narrowed pipe to draw another stream of water perpendicular into the narrowed pipe section; you can find one of these at an aquarium supply store. Carburetors work on the same principle.
Another explanation of the Bernoulli principle and air is that the total energy of a volume of air is conserved as long as there is no work done on the volume of air. The total energy of the air consists of it's kinetic energy (which is relative to a frame of reference), it's pressure, and it's temperature. For aerodynamics, the temperature component is ignored to simplify things. So if the kinetic energy of the air is increased without doing work, then the pressure of the air is decreased.
As I first pointed out, a wing performs work on the air, accelerating the air downwards (for a lift reactive force), and forwards (for a drag reactive force). With a typical, efficient, wing, most of the acceleration is downwards and only a bit forwards, resulting in a good lift to drag ratio. Some high end gliders have a 60 to 1 glide ratio.
I posted comments and links about wings and lift in this thread:
wings and lift thread