The firehose spray is traditional, as mentioned, for a retiring pilot or aircraft. It's a very nice touch for DFW to do it for returning troops.
I didn't get one when my unit got home, but then again we flew into MCAS Miramar in the middle of the night.