It's unfortunate you're being downvoted. Your intuition is spot on. Here's [0] a report from the Danish Environmental Protection Agency about life cycle analysis of different shopping bags. See table 4 on page 18 in the summary. A cotton bag needs to be reused 7,100 times and an organic cotton one even 21,000 times to reach parity in its environmental impact compared to a single use plastic bag that's reused as a trash bag.
There's plenty of other studies. Just search for life cycle analysis of grocery bags or similar on Google Scholar.
[0]: https://backend.orbit.dtu.dk/ws/portalfiles/portal/151577434...