The Iranians have no cruise missiles with that range. They have clones of the Soviet Kh-55. But since they ground launch them, unlike the Soviets which used the Tu-95 as a carrier platform, their range is severely curtailed. The range is basically cut in half.There's at least 1700km between Yemen and Israel. Just what cruise missiles do the Houthis (i.e. Iran) have that can boast kind of range, let alone the drones?
If the Houthis did launch them they're not trying to hit Israel but quite likely SA, which then leads to the question of "Why now?" and this convenience of a USN DDG which just happened to have parked in the right place at the right time to intercept, what, all 11 of those targets, drones included which were shot down using the SM-2s of all things to boot?
It is way more likely at a) the Houtis fired the missile at some other target or even the ship itself b) the US Navy is just plain lying. It wouldn't be the first time either. Gulf of Tonkin anyone?