'Ozzy was her biggest champion in her career and in love,' the insider told Daily Mail, adding while he might be remembered as a 'tough rock star, he was really an emotional teddy bear'