I think governments are afraid of nukes not because of the destructive power. Nukes are the only weapons that put the actual people in charge in danger, not just the civilians or the military. People in charge are afraid for their lives, not for the people they are supposed to protect.
It’s a simplisic view, I know.