Ozzy and Sharon Osbourne's son, Jack, comforted his sister Kelly during the Black Sabbath star's funeral procession in Birmingham