It can work for some people long term if they truly accept the person as they are and don’t get frustrated by them.
But often there will come a point, after the honeymoon has worn off, and after you’ve had sex too many times to count, where you suddenly realize that you’re not actually ever having conversations, you’re explaining stuff you found interesting to them, and getting nothing back. It can also get more frustrating depending on personality. If they’re always flying off the handle about stuff on social media and you have to explain why it’s not true, it will wear on you. If you always have to be the one to do everything, either because she doesn’t know how, or because you don’t trust her to do it right, then it will wear on you.
Personally that’s why I stress the idea of a partnership so much now. I want an equal partner who does everything I can do (or at least, most of it).
That being said, dating a 10/10 for a while and having a lot of incredible sex is also not an opportunity to necessarily turn down, especially depending on your age. If you’re young, go for it, have some fun, learn some lessons, have a lot of amazing sex, but get out early. If you’re older, then consider whether or not you can really be around that person, day in, day out, forever. If not bail now.