The pianist performed with the doo-wop group from 1970 to 2022 and co-penned “Sandy,” which John Travolta famously sang in Grease