The relationship between alcohol and stress is very complex, and if I'm not mistaken research shows that it can reduce resilience to stress. I didn't find dedicated studies on the issue quickly though. The ones I did find stayed that alcohol consumption for stress relief is associated with a higher risk for alcohol use disorder.

Personally, when I was still drinking, I avoided this scenario and never drank when stressed because of that issue.

https://www.youtube.com/watch?v=4xU5yIH_P9I talks about the issue, I guess there are more out there and it's not a scientific source. But maybe it's a start