The legendary Northern Irish singer’s recent output has been so bad, for so long, that the entirely decent ‘Remembering Now’ makes it seem like he’s made the new ‘Moondance’