Disaster on holiday

During a recent family holiday with dh dd x2 and their boyfriends ( dd are 25 and 33) my dh had a terrible reaction to a combination of wine/heat/ dehydration/ blood pressure tablets. He became abusive and delirium took over - at the time we thought he was just drunk. He said terrible things over and over again. The girls and I were horrified. Following day dh had no recollection of anything that had happened. When told of the events he felt ashamed and utterly devastated and apologised immediately to the bfs. He was not spoken to for several hours and the atmosphere was dreadful. Dds urged me to leave him. I said I wasn’t going to throw 37 years of marriage away bc of one awful evening. Eventually I felt it would be best if dh and myself left them in the villa and moved into a local hotel until we could find a flight home. We flew the following night. I msg the dds to tell them. No reply from anyone. I msged them after we arrived home to say how sorry I was that our longed for holiday had been ruined and I felt awful for them. I also said I didn’t expect a reply. I got a reply from the youngest dd to say she was heartbroken and would probably need therapy and time to come to terms with events. In the meantime I have had my dh crying and full of remorse. He has seen a GP and is starting therapy and isn’t going to drink alcohol again ( dd insisted). He has sent all 4 of them an email apologising again and offering the medical reason for his behaviour. Nothing. No response. He’s tried calling . Nothing. We are both heartbroken and so upset ashamed and don’t know the best way forward. Advice welcome.