Red wine in particular has a lot of flavonoids, which are particularly healthful, so it's plausible that there are some health benefits from it. The alcohol itself is probably not conferring any health benefits, though. As with most things, it's probably too simplistic to reduce it down to a single variable.