If UGK’s third album ‘Ridin’ Dirty’ found the duo on the cusp of national stardom, ‘Super Tight’ feels and sounds like it comes from a more honest and down-to-earth place.