Red wine does contain anti-oxidants which are indisputably beneficial for your health. The key to reaping the benefits of red wine is to drink in moderation i.e. no more than two glasses per day (this does NOT apply to people with liver disease).
The other potential hazard to be aware of with red wine is the preservatives - do you ever have a couple of glasses of red wine and wake up the next morning feeling fuzzy or stuffed up in the nose and head? You may have an allergy or sensitivity to the preservatives used in wine. Preservative-free wines are difficult to come by, but buying European wines is one way to avoid high levels of preservatives.
Red wine contains resveratrol, which is a chemical released by some plants. Research has suggested that it could have anti-aging properties, can be considered an anti-inflammatory, reduce blood sugar levels, and have cardiovascular benefits. However, the amount of resveratrol that red wine contains is so small that there are no viable health benefits to drinking it. The detrimental effects of alcohol is much greater.
When medical research found that people who drink one or two glasses of wine are healthier than those who drink other things or drink more or less wine, the drinking public jumped on this. We wanted to have our wine and people pushed all sorts of theories such as people who drink a glass of wine every day are happier and so they are healthier.
Later they found that it is only red wine that has the health benefit and so the idea it is the anti-oxidants in red wine that are good for you.
Life is about living. You don't have to be obsessed about being healthy to be healthy. If you want to drink a few glasses of wine every day then do it. Otherwise you would be better off getting your antioxidants from other sources such as green tea or blue berries.