The NFL figured this out decades ago - you need a stadium large enough to allow for a healthy secondary ticket market, but small enough to keep demand for tickets high at all times, even when a team has a poor season. TV is the rain maker, but the fans want to be able to watch a game at home once each season. But very few football fans actually want to attend every game.
It is possible to get fans into the stadium. Look at MLB. They still attract healthy crowds where teams have a solid fan base, and they have 10 times as many home games each season as college or NFL teams. But sellouts are just not as common anymore - in any sport.
MLB also has an entire different fan base as well, and an entire different season ticket holder situation. Most of your casual MLB fans don’t go for Wins and Losses, but go for the feel of the game, the promotion that night, or just something to do. Promotion nights (especially concerts, thirsty Thursdays, and bobble head nights) drive huge crowds. You also have those 50/50 raffles every night in which a fan can walk away with anywhere from 6k to 25k depending on the pot. MLB games are also typically at decent times of the day where you can go and not worry that much about work the next morning and are not burning up unless you go on a Sunday or that rare week day game.
Also there are far different options to be a season ticket holder, and many incentives to be one as well. For example, if you wanted to be an A-list member for the Atlanta Braves right now then you could get a partial season ticket package and choose to make it a personal package, a business package, or a premium package. With all of them you get free parking, discounted food, meet and greets with players and staff throughout the year, first options for post season and the 2021 All Star game, and discounted merchandise. If you only wanted to go to certain amount of games, we’ll say 8 out of 30, then you can donate those 22 tickets back to the Braves for upgraded seats with no extra cost. Also like I’ve hinted at, there really isn’t a wait list unless you get into very specific seating.
The MLB goes out of its way to make casual fans and season ticket holders extremely happy like no other sport with perks and overall experience. But also consider the number of games, types of people going, and type of game. The Atlanta Braves can take more financial risks for fan happiness than Alabama because you are talking about 80 plus games vs 8 games.
But I do think Alabama should do some things like the Braves do to make the fan experience better, like maybe have fan zones because your casual fan is only going to go and see the Bryant Museum only so many times. The Braves built an area behind the stadium with bars and shops called the Battery in which fans could mingle before, during, and after the game and get a 1st class experience. They have made bank because of it. I have came around to UAfan4life’s ( sorry if misspelled) idea of a concert or something after some of the cream puff games, but the problem with that is that you have no idea if that game is a 11 am, 3pm, or a 7pm game while the Braves know 95% of the game times in January already.