Catalysis of the reaction: (R)-3-hydroxylignoceroyl-CoA + NADP <=> 3-oxotetracosanoyl-CoA + NADPH + H+.