This question is for a Pokemon with sheer force(I could not put that much characters)
Yes, the effect will still be gone. Life Orb doesn't affect or change Sheer Force's mechanics, so the secondary effect of the move still won't apply.