There's downsides to heavy or frequent drinking, sure. But since the cancer risk is minimal, what's the downside of a glass of wine or beer a couple of times a week?
I'm less convinced of the negatives of this than I used to be. Humans are quite well adapted to alcohol.
If it's something you enjoy, I'd say go for it, in moderation. It's probably less unhealthy than e.g. living in a city, eating processed meat, or working an office job.
Its all fun and games until you get cancer. I had cancer (and a few drinks) myself, it sucked. Can you ever be certain it was caused by an unhealthy lifestyle? No. Probability and causality is weird tbh.