These naval CIWSs are massive. ~6 tonnes with a minute of ammunition. They cost tens of millions. All of this is probably acceptable for base defense.

But all high rate fire guns have short operation limits before their barrels melt. About 15 seconds before a 10 minute cool-off, maintenance and reload cycle. It's comically easy to saturate that with waves of decoy drones.