This is exactly the argument I have had with many hams. I have been in the ham world since the 90's and what I have found is that the direction that is accepted most by the ham community is that you get your Tech license and then you upgrade ASAP so you can get into HF and disappear into the worldwide bands. Allegedly, if anything hit the fan, HF is how they will communicate because all those nasty icky repeaters would be down. I have heard more disgust for repeaters and specifically the VHF and UHF bands because allegedly, they only have repeater operation (even though there is a group of guys around my area that utilize simplex on 2 meters every night....hmmm). So, what happens is that most hams run, get their higher class license, hop on HF and do what they do on CB radio - contesting (basically). Calling CQ over and over and collecting contacts. Hardly what would happen in an emergency. I am not bashing this because its part of the hobby and its one of the neat things you can do. But when it comes to being prepared for an emergency, you need to delve into another part of the radio hobby.
Theoretically, could ham radio be useful in an emergency? Absolutely! You have capability to communicate locally and internationally. The reality? How is anyone going to do that when they have spent most of their Ham Radio life doing POTA or SOTA or any other OTA? How are they going to do that when they haven't trained? Law enforcement of every type trains for the positions they are in at least twice a year if not more (Correct me if I am wrong). Military is constantly training. Hams? Most are unfortunately doing OTA activations. They have a training once a year for a few hours that happens and then they go back to their normal ham lives.
The reality is that if cell service went down, panic will ensue. People, if they are prepared will run and grab a radio. What radio will that be? Not Ham. It will be a GMRS/FRS type radio. If the majority of people will be there, why stick only with Ham Radio where only a select group of people will be?
I've seen some scary situations where ham radio failed and it could have costed lives. My take on it is to be prepared with your local bands and if you can have a Ham and GMRS license, do so. But I would imagine, to help your locals, GMRS/FRS will be where you need to be.