Barry’s inability to super-save everybody has forced everybody to be more resourceful, fulfill their own potential, and remind Barry (and viewers) that they can get by without having The Flash speed in to save the day.
Joe was a hero in “So Long and Goodnight” without Barry’s speed.
Joe was a cop before Barry became The Flash, so for all that getting shot probably wasn’t his favorite thing that’s ever happened to him, Joe accepted it where Barry couldn’t.