This probably happened once in Earth's history; Theia, the alleged Mars-sized planet that formed the moon in its aftermath when it hit 'us'. You're talking about the difference between some thousands or hundreds of miles in the Theia incident or the scenario in the clip, compared to something under ten or twenty miles in the Chicxulub event possible related craters, and earlier catastrophes such as the late Cambrian.
Today, in the middle age of our solar system and well past the early bombardment era, the Earth just doesn't recover from a scenario like this later on. Once the crust has solidified again, where in the hell do you expect to get the combined mass of the world's oceans back? Not likely. Earth is dead after this.
I think the clip has a nice 'oh wow....holy shit' factor to it, but we'd need something truly biblical to get this going...either something that can wrench Ceres or a moon from the outer solar system out of orbit and send it sunward. That or a freak rogue planet from interstellar space that were know are out there.
As far as your anxiety closet demons go, I'd be much more concerned about global climate change.