My first cotton skirt came from a supermarket clothing rail, a straight midi in a sort of oatmeal colour, and it taught me that cheap cotton creases if you so much as think about sitting down. I wore it to a lunch and spent the whole time looking like I'd slept in a hedge.
It is not the fabric for anything that needs to look sharp by six in the evening, because cotton on its own has no memory and no stretch to speak of. If you need something that bounces back after a long day, a car journey, a meeting that overruns, plain cotton will let you down a little. It is also not brilliant in a proper downpour, it gets heavy and clings in a way that is more annoying than flattering, and thin white or pale cotton has a habit of going see through at exactly the wrong moment, usually outdoors in bright sun when you least expect it.
Where it earns its spot is everything else. Spring through to early autumn, cotton skirts are the thing I reach for because they breathe, they do not stick to the back of your legs on a warm bus, and they look deliberate rather than try hard. For colours, I have had the best run with ochre, a faded denim blue, and a proper dark navy, all of which hide the general wear of a cotton weave far better than anything pale or pastel. White looks lovely for about one wear before a grass stain or a coffee drip tells on it. A mid tone always looks more lived in and less laundered to death, if that makes sense.
Cotton softens with washing, which is mostly a good thing, a new cotton skirt can feel a bit stiff and papery for the first few wears and then relaxes into something that moves properly. The downside is that softening often comes with fading, especially on darker shades, so a cool wash and turning it inside out buys you a lot more good months. Tumble drying speeds up the fading and the thinning, so I hang mine instead, even though it means they live on a radiator for half of October. A hot iron on the hem and waistband keeps it looking cared for, rather than like it has been balled up in a bag.
The one mistake I would steer you away from is buying it a size up thinking cotton will stretch to fit over the season. It does not stretch, it just sits there, slightly too big, until you give up and stop wearing it.
Keep going with fall skirt outfits.