I'm sure you are right RLS with respect to older ships - Most larger WW2 ships had armour - SNEBs would have been useless against those.
I would have thought modern destroyers and frigates would have effectively been soft skinned vehicles with plenty of venerable equipment above deck.
Maybe a QWI can help but I would have thought a pod of SNEBS would have produced enough damage, especially to the equipment such as weapons radar etc above decks to render the ship severely degraded as a fighting machine.
Of course a 1000 lb bomb is more effective - if you can get hit the target and get it to explode - They were big ifs during the Falkland's war. Also a risker profile.