The former vice president said his son had "never given up" during his years-long issues with alcohol and drug abuse