Because of something called being able to fire off axis and easily relocate.
You can put a turretted SPG in an area where there is only one way in and one way out, and not have to spend a long time rotating after firing.
Also, Russia, North Korea and I think China still use non turrets SPGs...