That's kind of why it's a big enough deal to kill yourself over it -that it is such a turnoff to so many people.
Just a minor quibble: a lot of trans people who commit suicide certainly dwell on thoughts like "no one will ever love me", but involuntary celibacy would probably be the bottom of the list of reasons why trans people attempt suicide.
At the top of that list would be lifetime of untreated gender dysphoria and being unable to integrate successfully into their target gender. Secondary reasons can include loss of job and livelihood, loss of friends, being rejected by spouse and children, being ostracized from church or other important social communities. Tertiary reasons include systemic discrimination in housing, employment, and access to healthcare.
Some trans people commit suicide for other reasons. For example, the stress of being a transwoman who is serving time in a male prison. The stress of multiple minority status, such as being trans and a felon, or homeless, or a ward of the state, or the child of illegal immigrants, etc.
One of the saddest cases I'm aware of was a transwoman who had come out to her parents at the age of 16. Her parents kicked her out of the house immediately. She had unstable housing, alternating between sleeping on friends couches and sleeping under a park bench. She made a mistake which resulted in a felony drug conviction. (Not sure which drug but certain cues in her physical appearance suggested meth.) After serving her sentence in a male facility in Iowa, she could not find an employer who would hire a felon, nor any apartment would not rent to felons. One apartment owner in particular told her that he didn't think people with her "lifestyle" should be living so close to a school where young children play. I met her at a PFLAG meeting where she told her story. She could not see her quality of life improving for the foreseeable future, no matter how many times people told her "its gets better". She killed herself about a year later. Her reasons for committing suicide are very complex; the best words to characterize her experience is that she had "fallen through the cracks of society".
Stories like that and Leelah's case are very sad not only because they result in a young person killing themselves, but that they are so easily preventable with proper family support.
By contrast, transgender success stories usually involve a strong support network of friends and family. Successfully transitioned people who feel comfortable in their own skin and are well integrated into their target gender generally do not commit suicide at any greater or lesser rate than the general population.