Yeah my understanding is that the balance of evidence on moderate alcohol consumption works this way as well (though with cancer and heart health reversed).
It was my understanding that many of the studies on moderate alcohol consumption included people in the study who could not drink for medical reasons (or were former alcoholics) which skewed the results for the zero-alcohol groups.
Studies on red wine included people whose only source of fruit was red wine, which similarly skewed the results.
Something can help fight cancer and also be terrible for heart health. The body is a collection of complex systems.