Plays a role in autotrophic carbon fixation via the 3-hydroxypropionate/4-hydroxybutyrate cycle. Catalyzes the acryloyl-CoA dependent NADPH oxidation and formation of propionyl-CoA. NADP(+) + propanoyl-CoA = acryloyl-CoA + H(+) + NADPH Monomer. Belongs to the zinc-containing alcohol dehydrogenase family.