I seem to remember the video, and at the beginning all the shooters were very confident that they would be able to shoot down the drones with their pistols. They soon found out it wasn't easy.
Later they swapped over and gave the drone pilots shotguns and the shooters the drones to pilot.
Didn't take long for them to shoot them down with the shotguns.
Also as previously noted bullets, even pistol bullets, travel a very long way before coming to earth and still have a lot of energy.
When going clay pigeon shooting (aka skeet in the US I believe) I was told that the lethal range (for people) with the shot that was in the gun was about 30 feet.
From popular media it seems that a lot of American Police cars have shotguns in them so I would have thought that will be the preferred tool to shoot down drones in most places.