Sheriff says Tennessee military facility blast was most devastating scene in his career