“Storm King’s Thunder” is a campaign-length adventure as players travel to and fro in the northern Forgotten Realms fighting cranky giants and trying to figure out why they’re all up to various destructive plots, apocalyptic shenanigans, and general tomfoolery all of a sudden.