A 2012 Canadian study concluded that resveratrol may improve exercise capacity and especially it may benefits people with restricted exercise capacity, like heart failure patients.

Contrary to many of the internet reports, red wine can not replace exercise

To be effective, the compound would need to be used like a performance-enhancing supplement, with concentrations far beyond a glass of wine.

Source: Jason Dyck, University of Alberta researcher, reveals truth behind wine study – British Columbia – CBC News