Cavalry charges were obsolete once the pike was implemented. Using cavalry after that point in time was limited to chasing down retreating troops and the previously mentioned roles.
Not so. See the battle of Kircholm from 1605 as a particularly successful example. Anyway, the discussion is about whether new technology (naval drones) could make old weapons (warships) and tactics obsolete. I thought you were saying that cavalry charges never happened and so never became obsolete. I'm glad that's not the case. But you yourself are saying that technology rendered cavalry charges obsolete. There are countless other examples; no one could argue in good faith that the once-dominant bronze chariot still has any role on a battlefield.
I just realized you're not the guy who said "it doesn’t mean the old ones are obsolete", so probably moot