The Irish Grammy-winning singer passed away from natural causes at the age of 56 in July 2023 - just 18 months after the death of her son (pictured in 1990)