If the activated ability resolves but the targeted artifact isn't destroyed (perhaps because it has indestructible or it regenerates), Hoard-Smelter Dragon will still get the bonus.