Now is my soul troubled; and what shall I say? Father, save me from this hour: but for this cause came I unto this hour.
Note 5 at Joh 12:27: Jesus was "troubled" (Greek - "TARASSO" meaning "to stir or agitate" [Strong's Concordance], see note 17 at Joh 11:33) by contemplating His death (2Co 5:21). His human emotions were so repulsed by the thought of being made sin for us that He actually considered praying His Father would save Him from that hour.
Even Jesus had emotions that were contrary to God's will. Heb 4:15 says Jesus "was in all points tempted like as we are, yet without sin." Therefore, we see that having an emotion or desire contrary to God's will is not always sin. It's when we yield to these thoughts by entertaining them that lust conceives and brings forth sin (Jas 1:15). Jesus refused to pray for His own desires to be met but rather submitted Himself to His Father's will by the words, "Father, glorify thy name" (Joh 12:28).