Sounds like your either relatively new working disasters or have had a good run of luck. I was a contract inspector for FEMA for more years then I care to remember and the first question when scouting campground/parking locations was about their refund policy. The majority of the places I've stayed have been willing to work with me even if they had a no refund policy after I explained the nature of my work. It's in your best interest to be completely upfront with the check-in people... even taking the extra time to contact the manager or owner to insure everyone is on the same page about your rate and situation. When I did encounter a park that wouldn't budge on the no refund policy I'd usually, depending on the size of the disaster, rent initially for a couple of days... or a week at the most until I got a handle on how much work was actually in the area as things have a habit of changing, especially during the first week of deployment. Of course if there was another park/CG in the area I'd contact them, explain the situation... emphasizing that I was contacting them because of the inflexibility of the prior parks refund policy.
Unfortunately trying to fight with a campground owner/manager over their no refund policy after you have checked in and paid will probably be a loosing battle.... so chalk it up to a lesson learned and get on with your work.
I don't know if the insurance guys have the same type of 'grapevine' that the FEMA inspectors do... but I'd certainly put it out there that you have paid for a months stay at the Campground... might be another insurance guy looking for a place close to his work area that could use it. I know that a lot of the FEMA guys were always trading/sub-letting extended stay hotel rooms as they moved around.