How far do you want to be from the stadium (which is actually in St. Petersburg, I believe)?
We just got back from 5 days in Treasure Island, it was at most 30 minutes from St. Petersburg. We stayed at a good Best Western, directly on the Gulf. There were a few other larger resorts, and some small hotels, also beachside.
You could also look for hotels in St. Pete Beach, or Clearwater, but Clearwater would be a longer drive to the stadium.