I'm probably in the minority but Sheeran's version always seemed credible to me. Even if he wasn't the actual shooter, him being there is perfectly consistent with how Cosa Nostra does many hits. A guy you trust sets you up and is there to put you at ease, your bodyguard betrays you and allows it to happen etc.

Which is probably why he was one of the top suspects from the very beginning.