His band, Frankie Goes to Hollywood, ruled the charts in the 1980s with their libidinous, unapologetically queer songs. Then he was told he had months to live. As a new exhibition celebrates Johnson’s art and influence, he tells the hidden story