Amazing 2 months ruined after he got cold feet post sex

He sent a text message today apologizing and explaining but now after 48 hours of crying and drinking I don’t think I can forgive him.. I really really hate how vulnerable I was with him just for him to get scared, take a couple days and now say he wants to continue.