Car rental at AlUla airport (driving to Tabuk)
 

I want to hire a car at AlUla airport and drive to Tabuk. I want to visit as many sites as possible on our own (sites such as Elephant Rock, Old City, Maraya, & Jabal Ikmah) I know there's also an animal park.
I know that there are some dirt roads, can someone recommend whether I need a high-clearance vehicle or if a regular (midsize) car will do?
Thanks.