I don't know if you've heard, but there's a new theory about how dinosaurs became extinct. But before we get to that, I'd like to go over some of the old theories.
So dinosaurs existed for about 150 million years. Depending on your definition of success, some would say that's way better than humans - though of course we're still going. But it would take a supreme optimist to believe that we'll last that long (having gone about 500,000 years depending on your definition of "human").
From a sci-fi perspective, humanity existing for 150 million years would be really cool - we might finally get flying cars. As for other definitions of success, we invented potato chips - enough said.