CIWS have a limited amount of rounds, and and are designed to stop a few large projectiles (think a cruise missile) sent sequentially. I'm not sure how they'd handle many drones, especially ones that could change course.

Throwing "wave after wave" of anything eventually overwhelms a defender.