That was indeed the plan and I'm still pissed we didn't get to see his version of RE4.Hmm, this is interesting: He planned on CV, RE0, and RE4 being a trilogy.
But at least we got Haunting Ground out of the deal which reused some of his original RE4 ideas and is arguably cooler than RE4 would have been (at least for me), but then he died before HG even released and HG of course didn't inspire a franchise*, just a sad waste all around.
*it really should have though, maybe the idea was that RE would become more action focused and HG would become the new "pure horror" series but I don't know whether Sugimura's death or simply a lack of sales or both put the kibosh on that idea.