Red wine has antioxidants in it. That's the primary benefit. It is good for you in moderation. From Wiki:
Resveratrol is an antioxidant found in grapes, red wine, peanuts, chocolate and certain berries, and it has been credited with a large number of health benefits in various studies. Now, however, a research team presents findings that question whether such benefits come from the compound.
Just be careful with red wine. It is acidic. When you drink it, you should be sure to rinse your teeth. Otherwise, it will lead to gum line and other cavities.