I agree with the notion that this is only good for Trips at this point - I agree that him constantly being in the title picture and in feuds only centered around the belt without any personal issues attached to it whatsoever lately, much like Batista (unlike the feuds of say, Cena vs Edge, which was hugely personal, or also Trips vs Orton after the Evolution split), and that has made him stale. Of course he is over as hell, and he is a competent in-ring worker... but if there is no other storyline behind his matches for years on end except that "Triple H wants/needs to be champion", it starts to get boring.
Now, with this move, they add dimension to his character, and people will actually pay attention to the feud, since it is something they can relate to, something that could happen in real life (someone attacks your wife/girlfriend), and something that makes you care about the person, and gets you interested in what is going to happen next, and whether he will get his revenge or not... Just think about the HBK/Jericho angle of last year... when they worked on the angle long-time, and got HBK's wife smacked by Jericho - well, that's what got people really into the feud.
And I really think it's a good thing WWE is trying to do a bit more down-to-earth with their storylines, focusing more on personal issues between wrestlers instead of simply their "drive to be champion" - that would suffice in a "real" fighting environment, if someone is simply "better" than the other... but in wrestling, you just need a good storyline that gets the fans involved on an emotional basis, otherwise there's no point in it all. But WWE made a couple of good moves lately, with the HBK/Jericho feud being very personal, then the HBK/JBL thing taking the current economic crisis as a basis, and now the Trips/Orton thing... it just makes the whole thing seem more real, and you have to "suspend your disbelief" less, simply because the storylines are not that much "out there". Also, the Jeff vs Matt feud will definitely somehow be appealing to people, simply because it is the "brother conflict"-storyline, which a lot of people will also be able to relate to.
So definitely some smart moves on part of WWE leading up to Wrestlemania, and, to get back on topic, definitely a good move for Triple H right now. They have a ton of potential with that Legacy storyline right now, especially if they play it like one of the McMahon's doublecrosses the others... we all know, a McMahon will never work as a face really, and especially not ALL of them - one has to have his (or her
) own agenda, and hopefully they'll play it out around that.