Iy was used and it did destroy ships. The Japanese name was actually "Ohka"
"1 April 1945: Six "Bettys" attacked the U.S. Fleet off Okinawa. At least one made a successful attack, with its Ohka hitting one of the 406 mm (16 in) turrets on West Virginia, causing moderate damage. Alpine, Achernar, and Tyrrell were also hit by kamikaze aircraft, but it is unclear whether any of these were Ohkas from the other "Bettys". None of the "Bettys" returned."
12 April 1945: Nine "Bettys" attacked the U.S. Fleet off Okinawa. Mannert L. Abele was hit, broke in two, and sank. Witnessed by LSMR-189 CO James M. Stewart. Jeffers destroyed an Ohka with AA fire 45 m (50 yd) from the ship, but the resulting explosion was still powerful enough to cause extensive damage, forcing Jeffers to withdraw. Stanly was attacked by two Ohkas. One struck just above the waterline, with the charge punching through the other side of the hull before detonating, causing little damage to the ship, and the other Ohka narrowly missed and crashed into the sea, knocking off the Stanly's ensign in the process. One Betty returned.
4 May 1945: Seven "Bettys" attacked the U.S. Fleet off Okinawa. One Ohka hit the bridge of Shea, causing extensive damage and casualties. Gayety was also damaged by a near-miss by an Ohka. One "Betty" returned.
