I also agree with this. Currently there really is no way to handle clothing stored in rooms. It will continue to accumulate. Forever. Until every tile in the room has dozens of tattered clothing items laying around due to all cabinets being full.
And even worse is that you can't even rely on old age to clean this up. If a dwarf has any children, their children will inherit items from their parents, so tattered pig tail socks will remain in the family for generations.
The only way I know of to clean up items is to either...
1) ...do not allow dwarves to have their own private rooms. If no one has a room, items left on the floor will have ownership revoked after a while, where it can be hauled back to a stockpile and automatically dumped into magma or into a refuse stockpile, depending on how you have your mine carts and stockpiles set up. This also causes negative thoughts due to dwarves not having their own personal rooms.
2) ...use DF hack to periodically clear ownership of clothing and order all tattered items to be dumped as garbage.
It would be nice if there was a way to self regulate clothing, so the player didn't have to manage it. Dwarves being able to automatically discard old clothing would be all that is needed. You'd still have a fortress full of old clothing, but its trivial to rig up mine carts and stockpiles to automatically dispose of unwanted items.
Helpful tip on clothing management:
By far the easiest way is to have a stockpile that accepts only clothing but no bins. It only accepts clothes and nothing else. Have a minecart sitting right next to this stockpile. It only needs a single stop. The mine cart doesn't actually go anywhere.
Order clothes to be loaded into the mine cart.
Create a refuse stockpile on the same tile of the mine cart, but have it accept no refuse. That it is a refuse stockpile is enough. Any clothing items located on top of this tile will rot, including items in containers. Mine carts count as containers.
Clothes will be hauled to the clothing stockpile and then loaded up into the mine cart. While inside the mine cart the clothes will quietly rot away to nothingness on their own. If masterwork items are destroyed the craftsdwarf will receive an unhappy thought. You will also receive an announcement about this. If a masterwork item, such as a sock, rots away on a refuse stockpile then no negative thoughts are generated. No announcement is generated either, which cuts down on spam greatly.
Do not allow the use of bins in the stockpile. Bins will get hauled to the mine cart while full of clothing. The clothing will rot away, but the bins will not. The mine cart will eventually get full of bins and no longer have any room for clothing.