The presence of antibiotics creates what's called a selective pressure in favor of bacteria with antibiotic resistance. Removing that selective pressure (i.e. the antibiotics) can potentially lead to the growth of non-resistant bacteria like your friend points out. But that doesn't mean antibiotic resistant bacteria just 'goes away.' There was a recent paper[0] published by the ASM that suggests antibiotic resistant genes can persist even in the absence of selective pressure. While I only skimmed over it, and it's certainly not definitive, it's very much an alarming conclusion. So while I understand his general point, I wouldn't bet the farm on it.
Already, we're seeing some pretty scary bugs with CRE (carbapenem-resistant enterobacteriaceae) and XDR-TB (extensively drug-resistant tuberculosis) and others. Festering in hospitals, where patients are at a much higher risk almost by definition, can create a real nightmare scenario that spreads outward from there. Even if that's avoided, antibiotics are almost a fundamental aspect of modern medicine. When they first came out, they were quickly perceived as an almost magical cure-all by the general public. Most people aren't able to imagine a world without them, let alone support the necessary steps to fight such a scenario. Medicine pre-penicillin was a scary thing, and no one really wants to think about the possibility of returning to it.
The body count--figuratively, literally, and economically--will likely be higher than a feared superbug as a result of surgical complications, the impact on organ transplants (if they're even feasible at that point), and a host of other problems brought about by common antibiotic resistance under the worst case scenarios. It's not a scary picture, and it's already here with thousands of deaths annually.
Unless some of the many ideas already being explored start to pan out, along with the discovery of new antibiotics in the interim, we're looking at a major step backwards to the 1930s. But that's going to require a lot of public funding and support. Personally, my nightmare scenario isn't a pandemic or a drastic decrease in survival rates for routine procedures. It's that we'll wind up having to experience one or both of those before the public starts to understand the problem and change their behavior. Maybe I'm being too pessimistic, but then I look at how antibiotics are treated in foreign countries and in livestock management, and I start to wonder if I'm not being pessimistic enough.
0. https://www.asm.org/index.php/journal-press-releases/94465-a...