The Grammy-winning songwriter told People, 'I saw her two or three weeks ago, and she was very thin. She had lost so much weight'; pictured in September 2023