The biggest takeaway is that almost nobody penciled in the Texans to beat the red-hot Titans on their own turf.
Sure, we can look to the "turning-point" play with the Mercilus pick, but it can easily be said that had there been no pick on Watson in the endzone to start with, there may never have actually been a turning point to get to later. Watson had bad plays and he had stellar ones. Same goes for the guy across from him.
Too much is being made over the throw out of bounds at the end, but you've got a guy hard-wired to extend plays and try to score without turning it over. If it's any type of real concern, then you run the ball. The call from the sideline dictated pass.
The Texans held Henry to 86 yards and no scores. It's better than anyone else had done in over a month. The secondary had its usual problems, but the Defense on balance held up their end of the bargain.
Special teams had an unexpectedly stellar game.
All-in-all, I think it'll have little bearing on the final two games of the season. The current Jekyll/Hyde streak will likely continue. The only good news is the final two opponents suffer from the same condition.