Yes, his own family wanted him dead and executed his murder, but I dont think that a "consigliere" was able to order the murder of influential Chicago soldier such as Roselli.

By the late 60's Roselli was in trouble with the law and also with his own family, probably because of the the LA group (right now I dont remember the whole story), and I think that by the early 70's Roselli lost his respect within the Outfit.

Accardo was the top boss of the Outfit at the time, who during the years of 1976/77 probably made all new inductions (according to North Side capo Joey DiVarco), although later or during the early 80's we have Aiuppa presiding over a ceremony. So my point is that either Accardo or Aiuppa ordered his murder, or both of them. Even Fratianno said something like he was allegedly questioned by Aiuppa regarding his thoughts on the Roselli murder.

We still dont have any clue if the old Chicago Outfit had a official consiglieri position but we have information regarding some non-Italian representatives who were often named as "treasurer", "advisor" or even "consiglieri" for the Italian top level hierarchy.

Also, if the rumor regarding Trafficante also asking for Roselli's life is true, then he had to be in agreement with the Chicago Mob. Trafficante was also close previously with Phil Alderisio and Dave Yaras.