The very last may not produce an all-clear in the short term, but it's likely to at least require lifting the “missile is likely to hit in our area soon” alert in favor of a very different emergency posture, which is a similar need.
If the US is going to exchange nukes with China or Russia, they could decide to wipe out Hawai'i. But N. Korea has like, what 5-6 nukes? They're not known to be accurate either.
Except for Honolulu Hawai'i is mostly composed of small population centers separated by miles of ocean or valley walls. If N. Korea decided that Hawai'i really had to go, I'd guess they could use their arsenal to kill/injure max: 6 missiles * 20k casualties = 100k casualties total, which would still leave 1.1million people to hear an all clear.