Blowing air directly into the end of a pipe does not produce any sound (well, hardly any!) or a standing wave.
In musical instruments, either there is a vibrating reed that generates the sound (e.g. clarinet, saxophone, etc) or the air stream is aimed at a sharp edge and the vortex pattern around that edge supplies the energy to maintain the standing wave (e.g. recorder, flute, organ pipes, etc).
If you want to produce a standing wave tone by "blowing into a bottle", you don't actually blow into the bottle but across the open end. The vortices are generated when the air stream hits the edge of the bottle neck. Since the edge of the neck is not very "sharp", the tone produced by blowing a bottle is not very loud or stable compared with a better-designed wind instrument.
The details of how this works get complicated, but one important parameter is the time it takes the blown air stream to travel across the opening in the pipe (while being affected by the changing pressure and velocity of the standing wave), compared with the time for one cycle of the standing wave frequency. If you blow too slowly, you don't get a softer tone, but nothing at all. If you blow harder in a controlled manner, you can excite a harmonic of the fundamental standing wave frequency. That is part of the playing technique for instruments like the flute.