The musician's novel about a salesman taking his young son on a road trip is reimagined as a six-part Sky series