Moskva sinking stands as just one of the numerous Russian failures in Ukraine. Just look at Belohorivka disaster where whole battalion tactical group was wiped out in the most stupid of circumstances. It doesn't mean that surface ships are outdated or cannot resist anti-ship missiles.
U.S. Aegis-equipped destroyers faced multiple strikes of essentially, same missiles in the Gulf of Aden, launched by pro-Russian Howthi (both based on Soviet Kh-35), with no hits and no even close calls (as far known, CIWS was never activated).