The president was visibly dozing off throughout the late senator’s memorial at Washington National Cathedral