I avoided sequin skirts for years because I had one bad night in my twenties where I sat down and left a small drift of glitter on a chair that wasn't mine, and spent the rest of the evening apologising to a stranger. Put me right off. What changed was realising the cheap ones shed and the decent ones don't, and that's basically the whole story.
A good sequin skirt holds up far better than you'd expect from something that looks like it belongs to one occasion. Mine's been worn maybe a dozen times over two winters, shoved in an overnight bag more than once, and it still catches the light the same way it did on day one. The trick is in the care, which is less fussy than it looks: never machine wash, never tumble dry, and if you can, hang it rather than fold it, because folding over time starts to crack the sequins at the crease and you end up with a pale line across the front that no amount of steaming fixes. A cool iron is out too, obviously, unless you want a small molten patch as a souvenir. Hand wash in cold water if it needs it at all, which with a night out skirt is rarely more than once a season.
In the shop, skip past how it looks under the lights and check what it's actually sewn to. Sequins stitched onto a decent base fabric will move with you and survive sitting down all evening. Sequins glued onto a flimsy mesh will start dropping off within a few wears, and you'll find them for months afterwards in the bottom of bags, down the sofa, in your shoes. Run a hand across the surface, press gently, see if anything comes away. Check the lining too, a proper lining means it doesn't cling or ride up, and check the zip sits flat rather than puckering, because a tight zip over sequins is asking for a repair job by October.
As for what not to wear it with, anything else that catches light is a mistake, one sequin skirt and a sequin top is a lot to ask of a room, and it rarely looks deliberate. Chunky knits fight the texture too, the skirt wants something smooth and plain above it, a simple top or a fine jumper, so the shine has somewhere to land instead of competing. Bare bulb lighting from above is also not its friend, but there's not much to be done about that one.
The real pleasure of a good one is sitting down in it at the end of the night and realising you can't feel it at all, like it was never there.