An iconic 90s rock star and former guitarist has shared a shocking health update with fans and posted a grim picture after announcing his retirement last year