The obit released on Tuesday also revealed that the former talent manager had a 'loving partner' before his death