This sort of thing has happened to me so many times that I usually wont go to parties and such anymore. I'm happily not married, so I dont have a partner to offend or anything. I do live with my father and stepmother, and I know they do wish I'd interact with people more, but they also understand that alot of the time, I just cant. They understand the whole autism thing, so while there used to be arguements about this when I was a kid (and was not diagnosed yet) that doesnt happen anymore. I mean, seriously, me going to parties is a total waste of time. One way or another, I absolutely will end up in a whole seperate room, wherever I can find, sitting by myself and messing with some gizmo that I'll have brought with me. Waste of time.
Besides: if I'm being 100% honest, there's one other fact: I simply dont ACTUALLY know most of those people. Yes technically the label of "family" is there, but these are people I see once in a blue moon on Friday the 13th when all the planets are aligned. In other words, super rarely. My mom's family in particular is both huge and spread all over the freaking country, and I have too many cousins. There are cousins I've never seen/met and dont know the names of... that's how many there are. Stepmother's family isnt much smaller, but is not spread out. And one way or another... particularly with my mom's family... I know next to nothing about most of these people.
Now, back as a kid, the one thing that DID get me to go to some of these functions was because my grandmother (on my mom's side) would be there. She's one of the few that I DID know, and she used to live far away, for my entire childhood. A few years ago though she moved back up here, less than a block away from my mom's house, so now I can just go visit whenever, instead of ONLY at functions. Which is nice. She's easy to talk to and watching her dog ricochet off the walls is always amusing. And she hates bad weather as much as I do. Was close to my grandfather too but he is unfortunately gone. And there's exactly two cousins and one aunt & uncle that I know pretty well, but again, not super rare that I see them. Pretty much all of the others though... yeah, I'm not going to pretend that I know them. Because I dont. I get that the family thing is important, but it doesnt change that fact.
Doesnt help that so many people are just boring.... I have a hard time conversing with most of the people I DO know, since they dont talk about anything interesting (except my grandmother, really).
Anyway, I dont think there's really much that you should be depressed about. The whole autism thing is what it is. It's not like you walked in there, went "you all suck" and walked out. You didnt do that. You simply hit the wall that pretty much all of us hit. It's just how it works, and it's not your fault, nor is it under your control. I mean, you can try to force it, but... that usually results in a variety of problems.
Yeah, your wife didnt like it, but if you've not been diagnosed really, and you both havent gotten used to the whole concept yet, well, it can be frustrating for those around you who arent used to it yet and dont understand. It takes awhile, for everyone to learn, you know? You'll just have to work that out.
Seriously. Nothing to be depressed about. Frankly you did alot better than many of us on this forum do. Quite a few of us cant handle socializing at events AT ALL (obviously there are exceptions though). That you managed some is impressive.