The lead singer of the Irish rock band, who died at 46, wrote songs in the 1990s that deeply touched young women and Irish listeners while appealing to a worldwide audience