The legendary musician looked frail as he had been joined by members of his iconic group The Beach Boys at the Los Angeles premiere of their Disney+ documentary back on May 22, 2024