The theme tune to True Detective brought The Handsome Family to a whole new audience, writes Don O’Mahony