Yes. Smaller rooftop tents, like the Thule Tepui Foothill, fit on small cars. Because this tent weighs just over 100 pounds, pretty much any car with a roof rack should be able to accommodate it.
However, larger rooftop tents like the Cascadia Vehicle Tents are heavy and bulky, so a truck or SUV will definitely be the best option to haul them.