In terms of perception, yes, to a terrifying extent. Most people think of nukes as really big, really hot grenades that happen to make mushroom clouds because science(?). That includes elected officials these days. They may not think they're underestimating nukes, but that's Dunning-Kruger for you. I'd rather we not learn how wrong we are the hard way, but I think the more Hollywood and video games nerf the perception of nukes, the easier it will get for elected imbeciles to use them.
Not to derail the thread, but I can't recall an instance where any video game gave me the impression the designer knew the slightest fucking thing about nukes. There's room in the world for absurdity, OK, so I'm not talking about Worms or Dragonball per se. If the story's taking itself seriously at all though, these things are fucking horrifying. An earnest portrayal of nukes should be causing GAFers to post things like, "After seeing that I couldn't sleep for three days," or, "Which more scary: the best survival-horror EVAR or a mediocre nuke sequence?" And if you can't pull that off. . . for the love of pants, don't try. Or just stick to making DB episodes.