There is an unexpected silver lining here. It’s unlikely the Houthis will be able to launch more than one at a time. This will give the USN a real-world test in a relatively mild combat arena. I’ve been concerned for a very long time that the US and other navies have been building ships and developing capabilities based on threats that are being replaced by more numerous, cheaper swarm weapons. Some of those will be hypersonic. Some will just be a cloud of tiny drones that will kill anyone on the deck and damage equipment but not destroy the ship. (A potential mission kill.) Others will be swarms of various size suicide drones and crewed boats.
The Russians in the Ukraine are using drone swarms to block and tackle for a concurrent missile strike. The Ukrainians are forced to down the drones and then are left with their pants down and out of ammo and the missile gets through. I doubt they will tack American naval ships because that would invite too strong our response, they’re just gonna keep picking off the cargo and tanker ships.