“Jimmy was up and running and in great shape – he was in fantastic form. I thought, ‘Job done’”: Led Zeppelin guitarist Jimmy Page and Bad Company singer Paul Rodgers’ 80s supergroup should have been huge. The reality was very different