Don't worry dude, you are 100 % correct. Don't let anybody tell that you should be compatible with every woman. That's bullshit.
Yes, you definitely can have drunken one night stands with woman who are not at all compatible with, but it will not last past that unless you become a totally fake person, which is no fun.
MOST girls I have sex with, I'm not really that compatible with, which is why I have a lot of one night stands. I'd say about 2 out of every 10 girls I sleep with last past a one night stand. Sometimes its because the girl doesn't want anything more than a one night stand and sometimes its because I don't want anything more. I'm starting to change that with the way I qualify girls and weed them out before we have sex, but I still don't weed them all out, because there are still plenty of girl I would like to have sex with regardless of whether or not we are compatible
YOU decide whether or not you want to deal with girls who are not compatible with you. There's nothing wrong with a one night thing, but spending a lot of time around girls who you don't even really like that much is no fun for anybody.