There's also the class of "Loitering munition", which was used to great effect in the 2020 Nagorno-Karabakh war.
https://www.brookings.edu/techstream/loitering-munitions-pre...
Similar parallels can be drawn to the Iranian attack on Saudi refineries recently. The line between cruise missiles and drones blurred.
So, yes, there is a move towards cruise missiles being chassis you can task with routine intelligence gathering, picket etc and even launching stand-off ordinance.
There was similar lack of faith in the British tigerfish in the 80s.
But generally modern torpedos are expected to work effectively and are tested.
Sweden is leading the way on the dronification of torpedos.
They are called UAVs and indeed cost millions each.
When people talk about how they can build lethal drones for $100 or something they assume that you can launch the weapon 3 miles away from the target and that the target has already been spotted.
It's like saying that a million dollars can kill a million people because bullets cost less than $1. Making the bullet is the easy part. You still have to deliver it to the target.
https://www.scmp.com/news/china/military/article/3147997/reg...
In 2015 the United States planned to procure 7,474 rounds with a FY2015 total program cost of US$1.9341 billion at an average cost of US$258,777 per unit.[6] By 2016, unit costs were reduced to US$68,000 per round