The Duke of Sussex spoke in depth about his drug use in his explosive memoir Spare - and it's caused issues ever since the book's release