The music legend, nicknamed the Prince of Darkness, married his second wife Sharon Osbourne, who helped him transform into a successful solo artist and the couple had three children together (pictured together in 2017)