'I am throwing in the shoes,' says 66-year-old David Lee Roth, best known for fronting influential band during its heyday in the 1970s and '80s