Self esteem is what you think of yourself. It is not about abuse by others or horrible life experiences, missed opportunities, or anyone else and what they are doing, thinking or feeling with regards to you or themselves or anything else.

You figure out what you would like and then you work on getting it. As you work toward and meet your own goals your good feelings about yourself should increase.

Why did you not go to the film by yourself if you could not find anyone able to go with you? Decide you want to see a specific film, not that you want X, Y, or Z person to see a film with you; you have no control over other people as they have no control over you. Yes, it is nice to have other people around us but not always possible and that's when we get into trouble, when we try to bank on other people and they disappoint us. But that is not about Self esteem; that's about them. Being disappointed is an emotion we all have and there's nothing wrong with it, other than it certainly doesn't feel very good :-) The next time you talk to them, you say to another person, "I'm disappointed that you couldn't go see the movie with me, it was a great movie and I think you would have enjoyed it." But deciding you are no good because someone else doesn't go see a movie you want to see with you doesn't make sense?