I think you've definitely been looking at the wrong statistics.
The link that you posted was a blogger with an agenda making assumptions and pulling statistics out of his ass from studies which he'd barely even read to prove a bigoted point.
So let's set the record straight.
The 41% attempted-suicide rate he quoted isn't among post-transition people. It's amongst the entire transitioning spectrum. So most of those suicide attempts are pre-transition. (Not to mention most of the people who do attempt it fail, and then come to regret attempting it later.) He made ONE valid statistical link in his post... "one in twenty post-op transsexuals change their mind after surgery," and "one in ten never adjusts and becomes depressed." He didn't cite the studies, but those numbers sound somewhat legit, more or less in line with other studies that I've read. So let's look at those "one in twenty" and "one in ten" regret numbers a different way... that means that 95% DON'T change their mind after surgery. And 90% DO adjust. Doesn't look so bleak then, now does it? And take away the wrongful 41% suicide attempt rate which he cited out-of-context, and his argument completely collapses into itself.
Here... here is an official scientific study that was done on the trans community. It was done in Sweden, and followed 324 sex-reassigned people for up to 30 years after transition and tracked their mortality, suicide attempts, and psychiatric hospitalization. Here are the results for the 133 FtMs in the study: (only including FtMs since that's what the OP presumably is.)
Post-Transition suicide attempts: 7/133 (5.3%)
Post-Transition deaths from suicide: 4/133 (3.0%)
Overall Post-Transition Mortality: 11/133 (8.3%) [the other 7 deaths were from causes like cancer and cardiovascular disease]
Psychiatric Hospitalization: (for non-trans-related issues)
Pre-Transition: 22/133 (16.5%)
Post-Transition: 21/133 (15.8%)
Source:
http://www.plosone.org/article/fetchObject.action?uri=info:doi/10.1371/journal.pone.0016885.t001&representation=PNG_Mhttp://s3-eu-west-1.amazonaws.com/previews.figshare.com/398398/860/p_01.pngSo, yeah... MUCH different picture. In actuality, only 5% of post-transition FtMs attempt suicide. Not 41%. And, well, all that the psychiatric hospitalization stats show is that those who had other non-trans-related mental issues pre-transition still had those same non-trans-related mental issues post-transition. And this paints a MUCH different picture than the widely-quoted 41% attempted suicide rate that you seem so worried about.
Here's another study, this time of trans youth.
In this one, 433 trans youth were studied. And these numbers are VERY encouraging.

So yeah... as you can see, the picture is anything but bleak for people who transition. The blogger had an agenda, and was pulling together a bunch of statistics from different sources to wrongly make the claim that a majority of trans people are unhappy with it. They're not. Over 90% are perfectly happy with transition, and this claim is supported by every single study I've ever read.
Also, as a successfully post-transition person, for me, it did get better. I went through a lot of mental hell during transition, wondering if I was ever going to make it, ever be happy, ever pass, etc, etc. And now I'm through the other side, with a job, family support, friends, and a great life.