Right, so the technical requirements are already covered, that's cool.
But, the point is, a CIWS mount on a Destroyer or Frigate has a good chance of being able to engage a shoulder-fired RPG since it is not that high above the waterline. On a Carrier, the PD mounts are situated much higher, and so it is entirely possible for an attacker to get inside the minimum range for those systems and fire his weapons (Thereby causing work for the Carrier's maintenance crew). Adding mounts able to protect the carrier at those close ranges strikes me as being not cost-effective (As well as your point regarding the ammunition expenditure).