The music icon reflected on his friendship with former neighbour Ozzy Osbourne following his tragic death