Nova Scotia's energy minister has resigned from cabinet over misogynistic rap lyrics he wrote before entering politics.