Reflecting on the experience decades later, Sambora said that – embarrassing as they are in the moment – mishaps like that are “what shape you as a pro”