The former talent manager died following a three-year cancer battle with melanoma and is the ex-husband of singer Kelly Clarkson; seen above in 2020 in Santa Monica