big hugs to you. I'm so sorry you lost your beloved grandma. I'm glad you were able to be strong for your mother.

It sucks to lose a friend. You're going through a hard time and they weren't there for you
I would have a problem with someone having sex in a shared room. Please keep in mind that you didn't do anything wrong. In fact you did everything right. You stood up for yourself and told you friend your feelings. It's her fault that she's rejected you.

You are grieving a huge loss right now. But you are not a worthless failure. Not by a long shot.