one thing to note: unlike cruise missiles, these will take up airbase runway space and time to launch! they can't be launched from containers like missiles. so the value of these cannot be compared to a cruise missile as runway space and time is very limited.
I don't know how many sorties can be generated per day per base, so that is a key determinant of how good this is. they should be compared to something with equivalent opportunity cost like a purpose built drone. And an empty drone piloted J-6 might not be too worth.
Also have to note that a fighter crash doesn't necessarily do much damage. Here's a picture of what happened in WW2 when a kamikaze hit HMS Sussex, a cruiser, not even a battleship.
It literally only can scratch the paint.
Now if you add a 1000 kg bomb though... then things get much more interesting. Almost no cruise missiles can hold 1000 kg, but a J-6 can. And 1000 kg is a huge payload that is usually only on drop bombs, but a 1000 kg cruise missile is absolutely devastating.
That pilot was dumb enough to fly direct into the belt armour, which in many late war american cruiser designs (Baltimore-class) or in this case HMS Sussex was thick enough to withstand an 6-inch salvo from some distance, he should have flown into the superstructure to deal any damage.
Also if he was a Zero, well, this plane weighs under 3 tons and is made from aluminium and wood mostly, flying under 500 kph at sea level in a level flight. So really no kinetic impact possible, would just shatter on impact - againt any thick metal surface -
And it appearently didnt have any bomb strapped on, or the bomb didnt fuse, since there is no marking of a bomb explosion on the ship's hull.
So no wonder it didn't leave a dent against 106mm of belt armor.
Any case, even if he where in an Oka, flying against the strongest part of any warship is just stupid.
Oka wouldnt have functioned either because the warhead was HE only, no Armor piercing capability, so at best an Oka would have had an effect like a HESH shell, if the fuse allowed such depolyment.
Edit:
One a better look, the plane looks like a D3A Aichi, since its landing gear is non-retracting, but same story, pilot just hit the wrong spot, a superstructure hit or better a hit into the bridge would have mission killed the ship and took it out of action for some weeks.
Regarding J-6 as a quasi cruise missile, we can replace the landing gear with tundra tires, so it can also start from any strip of grass land.
For a 1000 kg payload, it should be conformally placed on, or in the fuselage.
With a 1000 kg HEAT or AP warhead it surely does sufficient damage to warships.
We have to bear in mind that todays warships have barely to no armor in comparison to WWII designs so even a 1000kg SAPHE Bomb would sink a destroyer sized shit if hit at the right spot (VLS, Magazines)