Quote my old post,
RIM-66 has only been fired anti-ship by a Perry class FFG in the
80s, meaning to say when the US retired the Separate Target
Illumination Radar together with the Mk13 launcher the capability
went too.
There's still hope that other Perry class operators will do this
someday.
Unclear if Aegis ships can do this with SM-2.
In simple terms, the Perry class is a pre-Aegis ship with
separate weapon direction radars like STIR. The system was removed
from US ships to save costs when Aegis became more common. Only
non-US Perry classes still have it.
Unfortunately there's little hope. Now the Perry's are pure
point blank anti-sub frigates. The AB destroyers are more anti-air
than anit ship. Only the Tico cruisers are all-rounders but
accroding to wikipedia--and it is prob accurately, the US will
cancel the cruiser and stick with the AB destroyers. So the future
US Navy is hardly Harpoon capable, mostly concern with Standard
missiles and AB threats. Ship to ship battle wise, they won't
win.