Catalysis of the reaction: L-2-aminoadipate 6-semialdehyde + NADP+ + H2O = L-2-aminoadipate + NADPH + H+.
L-alpha-aminoadipate delta-semialdehyde:nicotinamide adenine dinucleotide oxidoreductase activity