Thank you, @Derpy and @Tam for your responses, very enlightening. I guess I don't understand how modern naval defense works nowadays, and had a cave-man like thinking of more guns or longer list of guns/weapons = good.
From what the both of you said, its seems more of a fundamental shift in naval design.
More guns is better but they need to be useful. The doubling up positions like the Type 1130s on the 054A or the AKs on the Kirov class are not offering twice the defense because only one of them can be used to intercept AShM. AShM pretty much nearly always will be coming from one side, if they are coming from both sides, no amount of RAM or CIWS is going to saving you because your fleet is probably sinking at this point. It's a downright stupid design to double them up. Maybe before the 80s and during the age of lone super flagships... even the Yamato was sunk with considerable ease on its own. If you want to double up your CIWS guns it's far better to have them arranged one behind the other as opposed to one on each side. This way at least they can engage whichever side missiles are coming from and actually double the amount of lead being poured into the air.
CIWS cannot be replaced by point defence short range missiles like HHQ-10 or RAM. Definitely better to have one of each as opposed to two sets of missiles. Having a redundant mechanical backup is always better and CIWS is proven. They're also far more versatile and cheaper for smaller tasks like pirate boats and small drones. Sure they only offer a few seconds of firing and very limited by barrel wear so the only real advantage of missiles is you can hypothetically intercept the same number of targets as you have missiles. A gun can maybe cope with three or four at most before running dry and overheating.