Fans had been hoping to see the Manchester music icon back on home turf - now Liam has revealed the painful reason he wasn't able to collect his award