I don't think we as laypeople should even attempt to draw conclusions from Ukrainian battlefields ourselves, seeing how strong the survivorship bias is.
Take FPV drones. In [1] Michael Kofman estimates (based on talking to a number of frontline units) that on average Or TB2s. Remember how they were the future of warfare after their success in Nagorno-Karabakh and the first few weeks in Ukraine? Few months later TB2s completely disappeared from the media, and I don't think many people are aware of how useless they became.
More generally, I think we're seeing a repeat of the century old debate over torpedo boats. People saw how torpedo boats were much cheaper than battleships and thought "hey we can have many of those boats, it'll be cheaper and more lethal". Turns out that range, coordination, sensing, targeting, and logistics are so difficult a smaller number of more capable platforms in well trained hands is both more effective and efficient.
In that analogy, those CCA drones are [torpedo boat] destroyers, not torpedo boats. A small number of somewhat cheaper, but still expensive platforms dependent on the exquisite core of the fleet (battleships, carriers, F-35s, or AH-64s) that doesn't go anywhere.
[1]: https://warontherocks.com/2024/04/mike-kofman-and-rob-lee-on...