From an artistic perspective, in some areas an operatic-style voice is just inappropriate. Operatic vocals on a punk band might be an interesting novelty, for example, but it's not usually what you want; you usually want something more like this: http://www.youtube.com/watch?v=xGjk1Y_j8QE
(From that perspective, metal was a fairly good choice for this interview, because operatic vocals are often appropriate in metal.)
There's clearly a safety margin in what vocal coaches teach, and I think it's safe to say that Ozzy must be over the margin, but the right side of critical.
I haven't heard him in a recent live performance, but reportedly Robert Plant has also ruined his voice. One person said that he "sounds like Winnie-the-Pooh".
The people at the top of any field you will find combine hard work with genetic predisposition. They can be an inspiration sure, but imitating them is unlikely to yield the same results.
Specifically, we're talking not just about "music" here - which has an absurdly broad definition - but "metal," which falls under the category of western vocal-led performance. There are rules to this, and while breaking them might leave you with something that is ostensibly "music," it may well not leave you with "metal," "singing," a "song," or a "performance."