The Charlatans’ Tim Burgess wanted ‘honesty’ when discussing drugs in new book