Personally I think Vito'r real reason for not going in on the deal was that he was not in control of it. He was just along for hte ride, and was more afraid that Sol would run amok than anything else.
...or that Sonny would run amok. The novel says Sonny wanted it because he was itching for some action on his own and to "get out from under his father's thumb."
