They won the game, just got fricked royally by the refs.
The score was 34-31 Houston, so no Detroit did not win.
I assume you are referring to the Forsett TD. The refs made the correct call based on the rule. You many disagree with the rule, but the blame goes to Schwartz who should have known the rule.