A cruise missile launched by the Houthis into the Red Sea on Tuesday night came within a mile of a US destroyer before it was shot down, four US officials told CNN, the closest a Houthi attack has come to a US warship.