Can you get really bad stomach pains if not drinking enough water?

Yes. Stomach cramps are a common, non-specific symptom for lots of problems. Volume depletion or dehydration can cause cramping as can electrolyte disturbance. Many other thing can cause stomach cramping, however, so if this is a recurrent or persistent issue you should see your doctor.