It didn't push me toward agnosticism (other life events did that) but I saw it at the same time I was moving in that direction, and it didn't turn me back.
I talked to the family minister about it at the time, and he said he didn't like it because there was so much emphasis on Jesus' betrayal and suffering, and almost nothing about the resurrection.
If anything it might turn your kids toward Judas. Now that I think about it I realize maybe it did push me toward agnosticism by making Judas so complex and sympathetic. Webber and Rice really portray him as a tortured instrument of God's plan. God sends his own son to be crucified, but Judas suffers just as much and gets none of the thanks. Well, he does get this bit of awesomeness: