I now wear hearing aids, and they’ve made noisy restaurants a lot more bearable, but still not perfect. They still let the noise in.
My solution is to (a) go at quieter times, and (b) ask for a quieter table. My wife and I went out to dinner on Friday night, and they put me next a wall, which meant that I could turn the microphone on one hearing aid way down (so it didn’t amplify the neighbour noise so much), and turn the other one up. It was so much better! And, even better, the restaurant manager said he’d add a note to my file - I have a file!!! - and they’ll try to get me that table every time I go.
I don’t find the hearing aid feature of the AirPods Pro to be very all that useful. I don’t know why tbh, just that if I had a choice I’d always have my tiny, lightweight expensive hearing aids on.