I can't see one particular compound ever being a substitute for general healthy living. I think one can do far more for longevity by getting rid of the chemically processed shit food in one's diet and exercise some vs. taking a pill.
Cannabis is an interesting plant, though, in that it is such a complex organism and that it does seem to have medicinal properties. I've always wondered if there are some beneficial compounds in cannabis (other than THC) that may help improve health. Especially now that vaping is an option (smoke in the lungs is never a good thing).
I first heard about that reservatrol compound in that badly worded article from studies over the "French paradox" -- that even with a diet high in saturated fat, French tended to stay slim with low incidence of heart disease. Red wine was postulated as one answer due to reservatrol.
Personally, I believe that it's more an overall diet thing in the case of the French. It does show, however, that a little of a potentially harmful thing won't hurt. Alcoholic beverages are another relatively complex substance (when done right) that has some interesting complex compounds that might actually help longevity. (As long as you don't overdo it, because alcohol the chemical is *very* bad for longevity if consumed in large quantities.)
I don't see any one single compound as being a miracle cure, though.