You are effectively driving the tweeter through a 10K resistor, so it will be extremely quiet. Instead of the 10K/390 ohm/2.2uF combination, try connecting the tweeter, a 150 ohm resistor, and a 10uF capactor in series, and connect that combination between D2 and ground. It may still be too quiet for use when paragliding, but you stand a better chance of hearing it.
I tried this with a small speaker and it wasn't very loud. Certainly not loud enough to be heard above wind noise.
BUT I tried it with a small set of head phones and a set of ear buds and it was very loud with both. I just copied this circuit with the 100 ohm resistor on pin D-2.
I wonder if a potentiometer where the resistor is would make the volume controllable.
I tried a potentiometer in the circuit and it worked great to control the volume in a set of earbuds.
I received the sound module today, and it drives a speaker great. Just connected the output from d2 to the input of the audio amplifier. Next, hook up a 9V battery and make a light weight enclosure and go flying.