Julen Lopetegui says he has endured one of the saddest days of his life after being sacked from his role with Spain, after agreeing to join Real Madrid.