Drones are fundamentally better than subsonic-Mach 4 missiles because they're 100-1000x cheaper, several times smaller, have a much smaller RCS, and have loiter ability. They're slower and pack tiny warheads relatively, but they're key to taking out mobile forces and other drones.
For fixed targets, that's something artillery and Shahed-like cruise "missiles" can deal with.
Those haven't made manned tanks obsolete yet.
There's going to be value in having a human "on site" to make decisions about engaging targets for quite a while from now.