Goddamn dude it does make sense and is consistent with his behavior. The commentators were talking most of the match "will Triple H make a mistake, he's not a pro reff". Was it "out of character" when the umpire blew armando galaragga's perfect game? Mistakes happen, and sometimes at the worst times. It happened in a real life, professional, high pressure sporting event at the worst time to a pro umpire. I don't think it's at all hard to believe that in kayfabeland triple H misses the foot on the rope.
How is it in direct conflict with his motivation? He made a kayfabe mistake, it happens in real life. Everyone involved in the story kept talking about Triple H making a mistake. It's lazy analysis on your part to discredit that. It's pretty stupid actually. Something that's logical and has a real life counterpart proving how factual it is that something like that happening in the context of the story isn't a plot hole. It adds to the story. If pro refs in matches will not make a mistake the whole match, then make one at the end, isn't it even more likely it could happen to Triple H?
I mean, the WHOLE REASON they were pointing out that Triple H was doing a good job up until that point was because they were worried he'd make a mistake.
Not only that, but we don't know if that was his full motivation for wanting to officiate the match, the story isn't over. Even if his motivation was for the match to be fair, him making a mistake doesn't discredit that. How does Triple H obviously trying his best and then making a mistake (which isn't out of character as I proved above) doesn't discredit his motivation for wanting to be the reff.
As for the Over the Limit thing, Christian turned into a chickenshit heel. The whole fucking point of him bitching is to turn into a chickenshit heel. The WWE isn't going to turn their top drawing babyface into a chickenshit heel.
However, since you think the ending was so fucking terrible, tell me how you would have done it. Please, enthrall me with your storytelling ability.