“Jimmy Carter was a typical Southern guy who grew up loving music and he was as true as he could be as part of that world,” the Band co-founder told Rolling Stone in 2023