Static friction doesn't always point in the direction opposite to that of motion. Imagine a book placed on a table. Put your palm on the top surface of the book and push it away from you. The static friction between your palm and the top surface of the book is in the same direction as motion. The kinetic friction between the bottom sufrace of the book and the table is in the direction opposite to that of motion. Friction acts to oppose sliding between 2 surfaces in contact. This is not always opposite to the direction of motion.
For simplicity, lets assume the turn is not banked, so that there is no component of normal force contributing to the centripetal force. In this case the centripetal force is static friction because there would be no other force that makes the car go in circles.
If the car was stationary on a banked turn, what you are saying would be true. Static friction would oppose the sliding down of the car and so static friction would be pointing up the incline. But when the car is moving, the static friction is centripetal because it opposes the car's deviation from the circular path.