Don't Look Up warns of a possible 'planet-killer' hitting Earth. How likely is that?

It’s a scene we’ve seen on screen before: Giant object hurtles toward us, scientists ring alarms, everyone panics. But while it’s a common trope in movies, just how likely is it that we’ll experience an Earth-ending hit from a comet or asteroid in our lifetime?