1000 drones of what size?
If they're small - like quadcopter size - then how did you get them in range of a ship more then 10 miles off shore?
If they're large, like back of a pickup sized (which is roughly a Shahed[1] - link for scale) then how did you transport and move them without being noticed and interdicted?
For comparison one of Russia's largest drone attacks on Ukraine, and thus in the world, happened recently and included about 1000 Shaheds over a distributed area.
You're talking about flying a 1000 of something into exactly one target which has CIWS designed to track and kill supersonic missiles at close range (and is likely in a flotilla with data linked fire control).
You might get lucky I guess but I absolutely wouldn't bet on it.
[1] https://united24media.com/war-in-ukraine/russias-new-jet-pow...