For visual and SAR, sure, but there are other missions like electronic warfare and signals intelligence that are still well served by aircraft.

Not by a mach 3+ aircraft. Good luck getting signals through the plasma of your own wake!