Yes. I think it was final resignation to what he'd become. The key, IMO, is when he returned to Tahoe--he knew Fredo had betrayed him, and Kay ignored him when he came in the door--and asked Mama if it was possible to lose his family.
Ntra la porta tua lu sangu � sparsu, E nun me mporta si ce muoru accisu... E s'iddu muoru e vaju mparadisu Si nun ce truovo a ttia, mancu ce trasu.