The US ends its Red Sea campaign not by victory, but by necessity – under relentless pressure from an underestimated Yemeni resistance.