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. Inactive towards 3-hydroxypropionyl-CoA, NADH and crotonyl-CoA. NADP(+) + propanoyl-CoA = acryloyl-CoA + H(+) + NADPH Optimum pH is 6.0 at 65 degrees Celsius. Retains half maximum activity at pH 7.5 at 65 degrees Celsius. Monomer. Belongs to the zinc-containing alcohol dehydrogenase family.