If you think about what you’re doing to the land you rip up while off-roading, the don’t-go-off-roading solution merits a look. As a hiker, if you could see yourself from my eyes, you would not like what you see. [Edit: ok there are better and worse practices of off-roading and maybe I shouldn’t assume you are not responsible... so disregard that if it doesn’t apply]. But yeah it would mean giving up some kinds of pleasure you’re indulging in now. That’s for you to decide.
As for the dream vehicle you describe, yeah electric won’t deliver that because for example the Tesla pickup and the Rivian won’t be cheap (one of your requirements). But there are costs you aren’t accounting for and probably never will if you’re this deep into it.
BTW Tesla AWD is insane and a step beyond normal AWD you are used to. So (when the truck comes out) the extra money is getting you something. The AWD is not the only thing of course but it is holy shit crazy good in their sedans, I can only imagine how it will be in the pickup.