Is there any 88N national guardsmen out there that can give me some insight on the MOS?

I'm in the reserves and all I can say is be prepared to be busy. For career progression, try to get into as many related schools as possible (UMODP, DOA HAZMAT, Certified Container Officer, & TC AIMS II Functional Users Course). You'll get some TC AIMS II training when you go to ALC and JOPES training, but the TC AIMS II Functional Users Course you can take and will be a little more in depth outside of ALC. Expect to possibly be an Unit Movement Officer (UMO) at some point as an alternate at least. I can't tell you how important it is to be knowledgeable in TC AIMS II. It's a system that virtually everything you need to do as far as the coordinating of unit moves is done in or is expected to be done in by Big Army.