The Irish singer, who became a household name with the release of her cover of 'Nothing Compares 2 U,' died at the age of 56 in July 2023