Remember you are only seeing a selection of the thousands of times this has happened. The drone operating side will release more of the ones where it didn't work.

It does work at least sometimes. If it didn't work at all soldiers would not bother carrying the shotguns.

https://en.wikipedia.org/wiki/Use_of_shotguns_against_drones https://www.businessinsider.com/ukraine-soldiers-best-chance...