The former president was honored at an emotional ceremony at the National Cathedral