To get to the "Super Bowl Sunday" Moment, you have to get through 45 other Madden Moments. Since all of these solutions focus on the final moment, it seems like that is pretty covered in terms of tips and solutions. However, if you're like me who had a lot of trouble with the Moments previous, I've got a few tips for you.
First off, use this site, which breaks down each Madden Moment and gives you pretty good tips.http://www.ps3trophies.org/forum/madden-nfl-11/69999-madden-...
Another helpful tool is this playlist with a few of the earlier (and more difficult) Madden Moments being successfully completed on video, including "Brady and the Jets", which gave me some trouble at first.http://www.youtube.com/playlist?list=PL416E1E0D4CEF3F0A
I used stat boosting and turned offsides off to get most of this games achievements. You can't do that with the Madden Moments. As such, you quickly have to learn how to actually play Madden relatively well. The first thing you want to do is to find pass and run plays that work for you.
In terms of run plays, the "HB Stretch" and "HB Power O" plays were consistently working for me. I generally used these to get a guaranteed 1-3 yard gain, to run the clock down, and most importantly, 2-pt conversions. I used the "HB Power O" most times and 95% of the time I could dive it into the endzone. Of course, you might find another run play that works for you, but make its something you can count on to get pretty consistently.
In terms of pass plays, there are a lot of options, but I found myself using the "Verticals" play the most often, passing to the "A" receiver. Another thing you should be aware of (which I did not realize until halfway through the Moments) is how the pass is affected by how long you hold the button down. If you simply tap the button, your pass goes to the end of the route and is thrown high and far. If you hold down the button, the pass is quick and low, aimed at where the receiver is currently at. I generally used the second method and looked for open receivers.
Another thing you will quickly learn is time management. For more tips on that, visit the earlier linked website.
Overall, don't give up. Some of them are really frustrating, but with a little persistence, you should be able to nail them. And if you are having trouble with the very last Madden Moment, just look at all of the other amazing solutions, and I hope this helps anyone who was struggling. :D