The Birmingham Museum of Art has a Norman Rockwell's America exhibit going on through 06 January. I saw it yesterday before the SEC Championship Game while the museum was less crowded (the Rockwell exhibit had a handful of patrons - there was no one in the other exhibits). I highly recommend seeing it to anyone in the area.

Bring your earbuds for your smartphone for the audio portion of the tour. They'll sell you a throwaway pair for a dollar if you forget, but you'll probably be much happier with your own.