Speaking on the The Magnificent Others with Billy Corgan in February, Sharon, who managed Ozzy from 1979 and helped shape his solo career, discussed the highs and lows