I lost the same position, which I was slated for, to the sister who was the current New Member Educator (she decided at the last minute that she wanted to continue on in the position). I was elected from the floor to another exec. position, but I was really disappointed because I had always wanted to be NME. I'm friends with her on FB and 30 years later, I'm still a touch resentful, because I don't think she knew how much I wanted that position! I can understand that it hurts now, but you sound like just the kind of person your fraternity really needs, and I bet you'd be a great advisor some day. People don't always appreciate the hard workers who get things done. Since my disappointment, I've served in many volunteer positions, including NME advisor to a chapter, so I guess I finally got my wish.
Hang in there! Elections can definitely bring out these feelings...you aren't alone!