That sounds good on paper. But the thunderbolt ports (usb-c) on one of my Macs have been fine for over 4 years, my Android phone has usb-c and is 3 years old. But I've had an iPhone that was less than 2-years old where the lightning port went bad and the phone would not charge properly, so I had to get the port repaired or replaced.
I watch a lot of repair videos and I see way way more instances of busted USB-C ports than Lightning ports. Of course your mileage may vary and the overall number of broken ports is probably well within the norm for both types.
For me, in my family, we probably have had over 50 devices with Lightning since the iPhone 5 (2012) and zero have needed the port to be repaired or replaced. I've had maybe a handful of lightning cables just "wear out", but I'd much rather have the cable wear out than the port.
I don't have that many USB-C devices in the family ... my work laptop, a few Nintendo Switch's, a few school Chromebooks, and Nintendo controllers. None have failed, either, so I have that going for me. The only thing is that the Nintendos can be a bit finicky on whether it wants to charge or not, but that might be more on Nintendo than the USB port itself.
I think USB-c will be just fine on iPhone. I mean it works well on the Mac and various iPads, so why would we expect it to not also work well on the iPhone as well? Lightning was a good solution but it's time to move on.
The difference between having USB-C on the iPhone vs. iPads/Macs is that the iPhone is typically used at a much higher usage rate. Plus, at least for me, it spends way more time in my pocket, collecting lint and other crap. It's used in outdoor environments way more often. So the ports may end up "abused" more often. Plus, my phone gets charge at least once a night, and with an aging battery, it's charged at least twice a day, plus I tend to charge it in my car when using GPS. So the port gets much more usage than my iPad (which I might charge twice a week, at most).
I don't disagree that the current Lightning connector is long in the tooth. There are things that it just can't do. But if Apple could up the capabilities of the current Lightning port to include the advantages of USB3/USB4 and be able to keep compatibility with current Lightning accessories and devices, I'd rather they do that. Alas, that probably won't happen and I'll be dragged into the USB-C standard eventually.