An asteroid or comet, just only about 3 miles wide could destroy all life on earth if it were to impact the earth. it wouldnt take much. Sure it wouldnt turn the Earth into pieces like the Death Star to Alderaan, but if it ends all life on Earth, what would it matter?
But you can put money on the fact that another Earth impact will happen. When? who knows, but as time goes on, the odds are not in our favor.
But even then, if the Earth and the human race avoid extinction from an Earth impact, in about 5-7 billion years, when the die begins its dying process, and turns into a red giant, it will swell out all the way to or very close to Earth orbit, destroying Mercury & Venus in the process, and if not destroying Earth, it will be turned into a hot, sphere of molten lava.
Nothing lasts forever.