In a non-uniform circular motion, normal force does not always point in the opposite direction of weight. Here is an example with an object traveling in a straight path then looping a loop back into a straight path again.