As far as something to be afraid of on a day to day basis, yes. This is speaking of both the real world and fiction. Fiction is obvious as to why, Goku can fucking blow up galaxies or some shit. Superman becomes God at some point or whatever.
In the real world, when is the threat of a singular nuke ever the case? Seriously, when? It’s always total thermonuclear annihilation. You never hear about a singular nuke. Most people fear being shot or stabbed more than total nuclear annihilation. The idea is too abstract.