Ahead of her new exhibition at Compton Verney, the cultural critic explains how myths and ballads transform the darkest ...