Was Hojo trying to get Red XIII to mate with Aeris?
Yes. Hojo's research would take around 170 years to complete, and in that time Aerith would die. He wanted a being with Ancient blood that would survive a long time, so he was hoping Red's longevity would carry over into the offspring.