There are "car cats". The closest soulmate I ever had was a domestic shorthair who died of lymphoma after four months of chemo last year. He was the most awesome car cat. He loved car rides. He'd lie in the rear window and chill out, or come sit on my lap and relax, or stand at the window and watch the cars go by. His favorite was going through drive-thrus. He loved to look at all the things going on in the parking lot. He'd run errands with me everywhere, and in stores where he was allowed, he'd walk on his leash and scope things out, greet people, etc. He only had one accident, and that was my fault. During chemo, he had to have LOTS of IV fluids. One day after his treatment, on the way home, I stopped at one too many stores, and he peed on the seat just before we got home. That was only a few days before he died.
I have two other car cats, too. But I have a couple who are DEFINITELY not car cats. They get so nervous on car rides that they poop, pee, or throw up. It's an individual thing, but your best chance is if you start taking them for rides early. However, I have heard that Bengals make good car cats.