Place it at the exact frame of the on-screen shot, after a short build-up moment. Pair it with a reload gun sound just before the shot for a complete action beat, then follow with a fail sound if the target comically survives.