This hasn't been covered much, but self-hating car enthusiasts are just as plentiful as self-hating traffic engineers if not more. It's like white guilt and "cis privilege" all rolled up into one. The FAQ on r/fuckcars even says "ackshually, car enthusiasts hate cars too because there's too many cars on the road."
From what I can guess, this guy fell down the urbanist rabbit hole and probably bought in to the whole thing without taking a second thought. Watching the video, his first reason is that owning 13 cars like he does is awful so he's selling some of them, which does make sense, but in the middle of explaining he cites the "cars are parked 98% of the time" non-sequitur that urbanists like to constantly bring up.
His second reason is that he wanted to make travel videos, but they do poorly on ad revenue, so he did car reviews instead which bring in more ad rev but they're not the kind of videos he likes. Ok, whatever.
Then his third reason is "Cars Are Actually Terrible". Yep, you can guess where this is going. He goes through the entire litany of standard urbanist talking points:
Cars are the only way to get around, zoning laws are bad, cars only benefit the auto industry, cars cause traffic, cars are dangerous to pedestrians and cyclists and drivers are terrible people, the yearly statistics related to fatalities from car crashes
("as car enthusiasts, I don't think we should be ignoring that" ??? terrible logic, I guess this means medicine is awful because medical errors cause 250,000 deaths annually in the US, more than cars' 43,000), blames traffic engineers and urban planners for people dying in car crashes instead of the actual drivers themselves
(I guess pharma executives must be personally killing 250,000 people annually too then?), 50% of trips made with a car are 3 miles or less, car ownership is expensive
(he "proves" this point with a non-sequitur about how if you invested the cost of lifetime car ownership ($450k) in the stock market instead, you'd get $6.8 million, which he claims is the opportunity cost of car ownership??? I could use the same logic to justify not spending money on literally anything), cars are subsidized
(doesn't mention transit is subsidized too), the auto industry "invented" jaywalking
(doesn't mention horses which used the roads before cars did), new cars are bigger, people are texting and driving because there's no alternative to driving
(no individual responsibility, all external locus of control here).
It's the end of the video now and he says he doesn't really hate cars, he just hates car-dependency and then repeats the slogans about safer streets while saying he only wants to use cars to do "fun" things and just hates having to use them to go to the grocery store(?). Uh, okay, that's some pretty strong doublethink there.
In any case, I don't know if these self-hating car enthusiasts realize that anti-car policies would simply make it harder to own a car and there's not going to be an exception for "but I only want them for fun stuff". But given that the guy from Hello Road has very strong doublethink, they probably don't know, or just think it's "for the greater good" anyway.