How long have you been together, and was this all part of a one-off episode, or are the drunken incidents a regular occurrence? Do you drink with your partner, or does he drink alone? Are you angry about the damage to your property, or about the drinking?
I think a lot depends on your lifestyle together. If your partner is living with you and you drink a lot together it is different from if he has moved in and gets drunk regularly while you don't. If the damage happened when you were both drinking, but he happened to be the one to fall on the table, it's not fair to keep reminding him that you own the house and paid for the furniture. In fact who paid for what isn't really the issue in any event - it's the behaviour that matters.
If he regularly causes damage when drunk, and you have asked him to stop drinking, or if he drinks a lot more than you and you feel that your lifestyles are incompatible, then it might be better to ask him to leave.
It really doesn't matter what any of us on here would do - it comes down to what you feel is acceptable - but for what it's worth, I think that saying he feels terrible about it is tantamount to an apology, but I would expect to see that backed up with a change in behaviour to show that he means it.