Ukraine has had some success engaging Russian surface warships with small aquatic craft type drones.
Does a ground-based operator pose a threat to modern navies by means of some swarm of jet-ski robots?
Getting enough of anything that can do serious damage to a ship to overwhelm the defenses is going to be an expensive undertaking. Maybe if some idiot sails a $10 billion aircraft carrier close to shore such a mass attack is justified, but it is simply not at all evident that "some success engaging Russian surface warships" equates to posing a serious threat to modern navies.
You don't necessarily need a lot of range if you launch them from a small drone vessel[1].
At the moment, yes, if you want to field a drone that can kill a ship then it's going to be expensive. But we haven't seen any real development of ship-killing drones because the Ukraine conflict is land-based with only limited naval conflict.
Military doctrine only really advances during wartime, by people in the field desperately trying new things to survive. If we had a naval war you'd very quickly see new advances in all this tech and I think you'd very quickly end up in the same situation; that large ships become useless archaic white elephants because they're vulnerable to drones.
Completely different class of drone capability. Something that could actually do damage in a naval context against modern countermeasure tech would be much more expensive.