I disagree about the CFB HOF. I went to the one in South Bend in 1995 when Texas played up there. It was ok, but not great.
I think what they have done in Atlanta is much better, and while it's not something I would go to Atlanta to visit, it is worth seeing if you are in Atlanta and looking for something to do. Definitely worth spending a couple of hours if you are a fan of the sport (which I'll assume you are if you are going to Athens to watch the Horns).
The Aquarium is cool also. (csb... in March of 2020 we visited the aquarium culminating in the show in their big auditorium filled with hundreds of school kids, basically the next day Covid shut down the world I remember thinking if my last public event was a show at the Atlanta aquarium I probably should have reevaluated my life choices. /csb)
Wish I was going next week. Should be a fun trip.