No, if you don't push it forward or move forward on the outside ski, it won't end up there. Inside leg flexion will hardly cause any tip lead. If you are skiing properly you are always centered on your ski's. Increasing tip lead causes you CoM to be forward relative to the outside ski, but seen over two ski's you are still centered, cause you are back on the inside ski. Which isn't a problem if your weight is on the outside ski.
If you move your CoM forward relative to the outside ski, the ski will bend at a different point. A ski will bend the most under where your CoM is. Tip lead allows you to manipulate that point. It will cause the ski to bend a bit more to front of the ski, cause that is where the snow will be pushing on it. Which means it will bend more. And if most your weight is on the outside, it doesn't matter that you are relatively back on the inside. The inside is not the ski that decides turning radius anyway.
Whether you want your CoM forward late in the turn is a matter of intent. Do you want to tighten the turn yes or no? If yes, then you want your CoM forward. If no, then no. Skiing is a game of applying and removing resistance to your ski, in order to facilitate circular travel and speed control. Edging by far has the most influence on that, but things like the position of your CoM, your speed, the snow conditions, timing all play a role on turning radius as well.