In all I've read on the Houthis I didn't see that the carrier group pulled out because of hypersonic missiles. It seemed more like the game of whack-a-mole was too costly. Can I read more somewhere?

I can't tell you the exact reasons why they pulled out. Those are just a few of the reasons why you can't just start carpet bombing or send naval assets into the Red Sea to protect civilian traffic.

OK but what point does this address?

That shutting down all traffic in the Red Sea would most likely have severe political and economical consequences. Taking major military action against the Houthis would do just that.

So unless you want to invade Yemen you can forget about simply bombing them into submission. That's not going to work. Hasn't worked for the Saudis, doesn't work for the US currently and won't work even if the US escalates it.