It seems like awful lot of hassle for nothing. Although if dwarves would be able to place requests to kitchen (Cafe mechanic, basically) or serve themselves that would make sense.
This would, ofc, come with a change to food spoilage. If food in your stockpile lasts ages, then what would be the point? However, as it stands, its just silly. Take two fish laying outside in the sun. They are side by side, laying on the same patch of dirt. One is in a stockpile (but not in a barrel) and the other is not. The latter will rot and the former will not. They are both outside, both uncovered, both in hte sun, both with the same vermin after them... but the one in the stockpile magically doesn't rot. What is a stockpile? Just a designation. Its just where your dwarves stack something. It doesn't take any rare materials, skill, or special conditions... but stops spoilage entirely (except for unprocessed fish, I think).
These changes would be introduced while taking those out. Things like flour would normally not rot if kept dry/away from vermin, but pig intestines in a barrel will rot -very- quickly unless eaten/processed asap. Dwarf fortress is supposed to be a simulation that introduces realism (as much as possible in a fantasy setting) to the gameplay. That is why pain, fear, and discipline are a large part of combat... as those overcome with pain will begin vomitting or go comatose. Those with broken hands can't hold weapons properly. Those with UPPER spinal injuries loose function of their lungs and suffocate (lower spinal injuries still let the dwarf crawl and even lead demonstrations, or work proficiently in anything if other people handle his hauling). The geology is in proper layers, water will flood with enough pressure, items get individually warm to the point of boiling away/burning/melting.... but food last indefinitely if your dwarves ask it not to?
This would also add more options to the game (dryers workshop, salt-masters shop, canning station... or these can be apart of a kitchen room). Using honey and wax to help preserve foods would also give us an actual reason to go after bees (no rock salt/sea water for salt? Don't want to sacrifice your iron for jars? Use bees!). This game is all about having options and choosing the right (or most FUN) path to... do whatever you want. More options and complexity is always welcome! Its more DWARFY damnit.