Did you ignore the V2 (rocket) because it didn't destroy a warship (I didn't fact check this, but it seems likely), or is your definition of an autonomous drone very restrictive?
Torpedo also should count as an autonomous drone (some were wire guided and not autonomous) and they were sinking warships well before WWII.