Slamming water to the point of nausea ("pounding back more than actually fits in my stomach") will deplete your sodium, especially under a good long ride. It sounds like you had a mild case of hyponatremia.