After his reputation was shaken by his controversial views on Covid policy, the Irish singer has put aside politics for his new record. It’s not particularly good – but that’s no surprise. Louis Chilton looks at the strange decline of one of music’s all-time greats