Smashin' asteroids, Hollywood style: could nuking an asteroid save the Earth?

With the recent success of NASA's DART mission, asteroid deflection technology has made huge strides. Where does that leave Hollywood's more cinematic portrayals of asteroid smashing?