This is by far the most difficult trophy in this game. You need to be in the "Madden Moments" tab from the main screen. You will only have 5 Moments to play at first and once you complete those 5, you will unlock another set of 5 Moments.
Each Moment has you doing something slightly different in slightly different scenarios. You will be winning in some of them and need to make a defensive stop. In some you will be losing by one or possibly 2 scores and have to pull out a win. They are all timed AND have the accelerated play/game clock, so keep that in mind.
The Super Bowl Sunday Moment is in the very last set of 5. I believe there is a total of 50 moments. So you have to complete 45 of them to even attempt the one you need for this trophy.