I don't know how capable the 30mm would be for anything faster than a large UAS or helicopter. The best information I could find was with the UK's Automated Small Calibre Gun which they will fit on their Type 26. Assuming CSC uses the same system then it's going to be ok for UAS and other slow flyers. But for killing small boat this would be great as that's really what it's designed for.
30mm Machine Gun System
The 30mm Machine Gun System (MGS) offers superior capability in defending against multiple threats, including unmanned aerial systems (UAS).
www.baesystems.com
The RCN datasheet for the CSC lists BAE as the 30mm gun supplier so it's likely going to be the BAE 30mm Machine Gun System which seems to be the North American distribution of the Rafael Typhoon Mk-30c rather than the MSI DS30M. The marketing angle for the 30 mm Typhoon over the previous 25mm Typhoon is improved C-UAS capability due to 30mm air burst munitions, higher max elevations for the mount, and newer tracking algorithms, but as you say, it'll be most effective against FIAC using super-cavitating swimmer rounds.
127mm with Hyper Velocity projectiles are being considered for missile defense because of their rapid time to intercept and ability to maneuver. Not sure how effective that would be, given skin-on-skin contact would likely be required unless they are making HVP's with explosive heads now.
According to slide 16, only the railgun HVP was supposed to have a KE warhead, while HVP for powder guns would have HE warheads. Sadly, HVP seems to be cancelled now.
It's great that someone is taking the initiative to try to develop a modern take on the Phalanx/Goalkeeper. The timeline seems long though since the article says the 'CIWS II' won't even complete development until December 2030, which means it could be the mid-2030s before the 'CIWS II' is fielded in numbers and reaches FOC. By the time it's fielded, evolving threats may have degraded it's effectiveness and alternatives like DEW may already be available.Hanwa and LIG NEX 1 are designing and building competing CIWS built around the GAU-8 30mm gatling gun for the ROKN. Both will have an AESA radar and an electro-optical targeting system (EOTS).
MADEX 2021: LIG Nex1, Hanwha Systems showcase competing designs for RoKN's CIWS-II programme
South Korean companies LIG Nex1 and Hanwha Systems have showcased models of the close-in weapon systems (CIWSs) each of them is proposing to meet the Republic of Korea...www.janes.com
These will be interesting and if they come to fruition with offer a viable alternative to what's available now.
It'll be interesting to see how CIWS evolves for lower-end HVU like AORs to meet the increasing threat environment. Do they continue to be treated like auxiliary non-combatants, heavily relying on other ships to protect them, and just have their 1 or 2 bolt-on Phalanx replaced by 1 or 2 bolt-on SeaRAM or 'CIWS II' or do they need to have more robust self-protection capabilities with a 3D air search radar, CMS, EW, decoys, and longer-range effectors? For the RCN, the Protecteur-class seems to lean toward the later philosophy being equipped with a Sea Giraffe AMB, CMS330, EW, and decoys. They are going to have 2 x Phalanx on delivery, but the sensor and combat management fit is ready to support CAMM if ExLS launchers are added.That radar/EOIR sensor package seems to be the big leap forward here. Married to a SeaRAM, DEW, or similar it could be a very nice inclusion on a ship that doesn't want/.isn't able to integrate its own sensors to the CIWS.