Catalyzes the dehydrogenation of 3-succinoylsemialdehyde-pyridine to 3-succinoyl-pyridine in the nicotine degradation pathway. 4-oxo-4-(pyridin-3-yl)butanal + H2O + NADP(+) = 4-oxo-4-(pyridin-3-yl)butanoate + 2 H(+) + NADPH Alkaloid degradation; nicotine degradation. Belongs to the aldehyde dehydrogenase family.