So, Bernoulli is in my opinion one of the most confusion inducing equations out there. So, I didn't read everything thoroughly, so forgive me if I re-state some things. I'll probably also do not adres all earlier examples.
Bernoulli is an
energy conservation statement. This means that it only applies as long as
you do not add energy to the flow!
Bernoulli equates to a constant (the total pressure usually), but that constant changes with reference frame. So you cannot directly compare a 5km/h car with a 300km/h car with Bernoulli. Going from 5 to 300 adds energy somewhere, so Bernoulli does not apply.
If you compress air in a confined space (e.g. a syringe like), you add energy -> Bernoulli does not apply.
If you heat or cool air you add energy (provided that this heating or cooling is not due to the adiabatic compression or expansion of the air)-> Bernoulli does not apply
If you accelerate flow by some fan or propeller -> Bernoulli does not apply
There are Bernoulli variants for unsteady flow or compressible flow, they look different however.
So the statement "accelerating flow leads to lower pressure" is misleading and certainly not true in general. Take a fire hose which is open at one end (no nozzle). The pressure at the end (where the water flows into the open atmosphere) is very close to atmospheric pressure. Ok, now add a nozzle at the end. This constricts the outflow area and usually greatly increases the flow velocity. Is the pressure at the nozzle exit now lower? Nope... it is still about atmospheric pressure. But you need energy to accelerate the flow, what happens? It is actually the pressure of the flow inside the hose that
increases! Of course, the pump that supplies this pressure must be able to do so, though.
But, Bernoulli is still valid in the sense that the pressure just before the nozzle is higher than halfway of the nozzle, and this pressure is again higher than the one at the exit. This is because this pressure is converted to speed (i.e. kinetic energy) by the nozzle. Now Bernoulli states that the sum of pressure and kinetic energy remains constant, so if the kinetic energy increases the pressure must decrease. This is all fine, but you cannot directly compare the case with nozzle to the case without nozzle...
So, now take external flow. I.e. the flow around a car or airplane or whatever. As long as it is not somehow confined. Also, take a case for which Bernoulli applies and remember what I said: adding energy to the flow causes Bernoulli to not be valid anymore. How do you accelerate external flow without adding energy to it?!? Think about it...
A Venturi doesn't work, that's internal flow. Accelerating it in, say, X-direction would require energy right? So how it that possible? Well, if you think about it, you'll notice that just accelerating the flow in only one direction simply will not be possible without adding energy. So, the kinetic energy that an air parcel picks up in one direction, it must lose in some other direction... That means the air parcel must be going around a corner! The airflow is bent somehow. This air bending requires pressure to do, and that's what changes the pressure around e.g. a wing. The shape of the wing makes the air take a turn, but the only thing that changes the direction or velocity of an air parcel is pressure, so the pressure
has to change to make the flow go around a wing (or a car, or whatever).
This change of pressure is described by Bernoulli, but only if you know the velocity. So how do you know the velocity? For that you must solve some other equation (the flow potential, or the Navier-Stokes equation, or whatever), and this actually solves both velocity and pressure (and density, and temperature, if you add it). In other words Bernoulli is adhered to by Navier-Stokes (you can derive Bernoulli from Navier-Stokes), and this is also true for the velocity potential equation.
So, now to add the last bit of complexity:
First take some air parcel that goes around a circular arc at constant velocity for whatever reason. The kinetic energy stays equal (since energy has no direction), and thus the pressure must stay equal. However, an air parcel must feel some pressure
gradient (directed to the center of the circle) to be willing to go around a corner (you need to 'pull'/'push' the mass of the air parcel around the corner somehow).
So what does that mean, say the pressure of that parcel is everywhere exactly atmospheric. Then the air parcel that is right next to this parcel at the inside corner must be at a
lower pressure, otherwise there would not be the necessary pressure gradient to let both parcels go around the corner. But if it is at a lower pressure, it must also be at a higher velocity due to Bernoulli. And exactly the opposite is true for the air parcel at the other side of this atmospheric parcel, this one needs to decelerate and be at a higher pressure for the gradient to exist. So, for air to go around a corner, at least some of the flow must be accelerated or decelerated somehow. But acceleration of an air-parcel in one direction without deceleration in another direction is not possible without adding energy.
I hope this clarifies some things, and hopefully does not add too much confusion

. Bernoulli can never give the full explanation for why air has a certain pressure somewhere. So you cannot use just Bernoulli to compute the airflow around a wing, you'll need other equations as well. Bernoulli is in the end just an energy conservation statement...