I can only speak of the Roth hit...but I never thought of it as a definite suicide mission. Sure, Rocco's chances of accomplishing it and getting away alive were slim...but he gave it a try.
Michael most likely didn't give Rocco's survival a second thought. He wanted Roth dead and simply chose the best man for the job. It was up to Rocco whether he returned home or not.
And as for loyalty...you're working for Michael Corleone, you know what he's capable of, and he in effect orders you to carry out a nearly impossible hit, one in which you might very well lose your own life.
What do you say...?
"Gosh, boss, I don't know...it's just too dangerous I don't think I want to do it. Could you get somebody else."
At the very least, loyalty increases your odds.
Apple