Reportedly the Moskva's radar system only covers 180 degrees, so the Ukrainians used the drone to distract the radar system, this combined with the high turbulent seas causing artefacts on the radar make it very hard to defend against anti ship missiles.

I presume most more modern ships don't have radars that can only cover 180 degrees so they would be as vulnerable to this attack.