Most likely the SPG Ts and Cs won't allow use of the override during special events.
All major chains have likely committed their room blocks to whatever entity controls hotel rooms during the SB period. I'm not sure when any unclaimed rooms would get released.
When the 49ers played in the SB in New Orleans (1990 maybe) triends of mine stayed in Pensacola and drove in.