'It's Over': Barry Manilow Reveals Devastating Update on Career Following Lung Cancer Battle — As Iconic Singer Fears 'This May Be Goodbye'