Sorry about your experience. We have a similar thing every summer, and ours also get booked up before smart pricing gets smart. You live and you learn and you learn the limits of smart pricing - I guess... I wouldn't say you didn't something wrong, hopefully you'll get some good reviews from it that will allow you to get more bookings where you can set the price higher, for example through rule sets.
I would look at rule sets and maybe use smart pricing for the non-football weekends, and create rule sets that you can apply to all football weekends, that way you can define price, check in & out days etc etc...