Hi Jennifer: This wouldn't be Keesler AFB per chance? If so, been there!
Your concern may be well founded, depending on what the inspector means by "...some pier work may be involved..." This could mean many things, and you will need to find out specifically what it does mean.
In this part of the world, termites are a grave concern. Rotted wooden posts, joists, subflooring, etc, etc will mean big time major repairs. A termite report will be very important on a house of this age in Mississippi.
It is not unusual on a house this old to have the concrete or stone piers settle a bit, leading to a sag in the member supported by the post on the settling pier. It may be nothing more than shimming or perhaps replacing the post on the pier. But if this is the case, you will need to find out if this will require jacking up the sagging weight bearing members under the house.
Grading of your property is very important. Our first house was a turn of the century vistorian we bought for a song in 1973....only to discover that the property had build up over the years around the poured foundation, leading to a situation where water run-off drained toward the house. Bummer. I wound up having to jack the entire house up 18" and then pouring a tied-in foundation wall extension to the existing wall, then bringing in about 18 yards of top soil to regrade the yard around the house so it sloped away from the house's foundation. A lot of work, but there really wasn't an alternative. Even with posts and piers, standing water under or around your new house is not good and will have to be dealth with.
Best wishes and I wish you many happy years in this (or whatever house you decide to get) for the remainder of your time on A/D and in retirement.