I have had a painted floor in my basement sewing room for 10 years or so. But I do not live in an area with cold winters and moisture is not an issue.
I am in the process of converting my exh's office into a long arm room. I ripped up the carpet and plan to put down vinyl plank with the underlay that is often used under laminate under it. I will have anti fatigue mats in front of the long arm machine.
Personally I would not have carpet in my sewing room, I sew barefoot and do not want to worry about stepping on pins. I also hate having to cut threads off the vacuum cleaner.