But on the other hand, they might be the solution to an oncoming asteroid, which could have destroyed us for millions of years.

Not much of a point in nukes' favor since there are so many other ways to redirect asteroids; even if nukes had a niche for taking care of asteroids very close to impact, it'd probably be vastly cheaper to just put up a better telescope network to spot all asteroids further off.