“The rock business has become so established, and so much like a society, that I have revolted against it.” After killing off Ziggy and breaking up the band, David Bowie recorded a covers album in a French castle. This is the story of Pin Ups’ creation