He had a good second half until he evidently got giddy and tried the trick play. They score a touchdown there, and it's a game, with the defense fired up and the offense hitting on all cylinders. The turnover, especially how embarrassing it was, completely changed the complexion of the game. On both sides of the ball, the mindset was that after the Henry TE to start the game.
In other words, I don't think Brady has been exposed as incompetent or anything. On the contrary, the debacle might have served as a needed reality check after three successful game. He'll be humble and hungry, eager to prove that he's not an utter idiot.