also use 3 9 volt batteries hooked together, i ran into the exact same problem

I would say that the reason its not doing much is that the barrel is simply to big for the tank. At 40 psi the air spreads out to much for it to be very effective. I would suggest using higher air pressure and shoving the projectile to the back of the barrel.