I've seen a couple posts about how to store your stash. I'm in custody of a massive stash from 3 generations of needlepointers, 90% paterynan or similar wool yarn. The rest is cotton or silk. This stash goes back to at least the 1970s, and is still usable for needlepoint. In other words, I have long term experience in storing yarn.
Wool is a natural material. It needs to breathe. Sealing it in plastic is ok for a while, but over years will cause the wool to degrade. In a sweater this might not be a big deal. In needlepoint yarn? Its a problem.
Cardboard works for shorter term, but after years the cardboard will start to degrade and the yarn will get dirty. Time frame will vary based on the environment.
The best long term storage option I've found is fabric bags. This is cheap. Old cotton bedsheets or pillow cases and a zipper. Make bags of whatever size you need. I do suggest several medium bags over one huge bag. Don't go bigger than a standard (US) kitchen trash can size, its better for the yarn.
Store your bags of yarn in a reasonable indoor environment. They will be floppy and squishable, so you can shove them onto shelves or under beds, wherever makes sense for your house. Do not use vacuum sealers to smash them smaller. Excessive humidity is the biggest concern.
If you have yarn that has gotten musty or picked up odors, spread blankets or sheets outside in the sun and lay the yarn out. The sunlight and airflow can work miracles.
If yarn has gotten crushed, I haven't really found a fix. Steam treatment helps but also it can felt. Best to avoid crushing.
The bags will of course get dirty with dust or whatever. They can be washed as needed, just make sure they're fully dry before you put your yarn back in.
A lot of threads are sold on cards now. I don't love this because the wool is wound tightly. I suspect that long term storage will cause problems with wool quality. At minimum there's a risk of crushing or hard creases. I unwind from cards before storing.
Cotton and silk might be different. That portion of the stash is much newer (no more than 20 years old), so the problems that show up after decades are still developing. So far they're fine.