I think he will stay here unless something crazy happens. Anytime things where going well Houston has shown they will get rid of whatever is causing him a problem. They key to righting this ship is to somehow trade Paul and getting a good return. Outside from that unless we strike gold in 2nd round draft. I am sure Morey is talking with the Lakers trying to pawn him off to them. At least I hope he is.
I think it's much more likely the Rockets would want a divorce before Harden does. Once Tilman and Morey realize a rebuild is necessary, I would expect both sides to work towards a mutually beneficial parting. Sadly, we very well could be stuck with Paul even if Harden is traded. But, I really don't think anything will happen anytime soon.(although who really knows with Morey as GM) I think Morey will continue to tinker with the lineup surrounding Harden and Paul and hope to find that magical combination of players that makes them a contender once again. It's just tough when you have so much money tied up in so few players.