For the corner case you've described, I think you'd still find the Cybertruck to be out beyond its capability. It'd be better than a paperweight, in that with the solar canopy and/or spreadable solar, you'd be able to generate some power and be able to eventually return to civilization (after the sun is back, maybe after the snow has melted - I hope you packed a lot of food along with you
).
The key items you mentioned that lead me to this conclusion - 2' of snow means your energy consumption, even with cabin heat turned off and driving slow (which you'd be doing that far away from anything resembling pavement and in 2' of snow, is going to be very high per mile. Even with range mode or other setting that minimizes the battery heating so you're converting as much of your energy expenditure into moving as possible, you might be measuring your consumption in kwh/mile instead of wh/mile (snow increases rolling resistance a LOT over clear/dry/flat pavement). You also mentioned bringing 30 extra gallons of diesel and using all of that as well.
The energy content of diesel, even if we reduce it by 2/3rds to account for the efficiency loss associated with burning it, means you brought something like 330 kWh of extra range with you, which I'm guessing is around 800 miles of range for CT (given clear / dry / flat pavement). If we triple consumption for the conditions you had (I assume elevation gain / loss, snow up to your axles, cold), that'd be something like 250 - 300 extra miles of range for CT. And you still used it all. It's going to take a long time for an onboard solar panel / spreadable panel to generate that much power to move the truck back to a 110 outlet (or better).
There's a lot of similar corner cases where CT will work well, just not as extreme. And my own guess is that 500 mile range in a few years will turn into a 1000 mile range vehicle in < 10 years. It'll be an expensive option, but for the really intense and sustained energy consumption scenarios (such as what you've described), that'll be what's necessary. The primary use case I see for a 1k mile range vehicle will be a towing vehicle with a big / heavy 5th wheel in tow. I'd expect those bigger loads to triple energy consumption, so the 1k range vehicle will provide 300ish miles in practice. I don't expect very many of the 1k range vehicles to sell, but I do expect it'll be a necessary vehicle for the latter stages of providing electric vehicles for the wide variety of today's use cases.
EDIT: adding - the range loss (vampire drain) is pretty manageable. You can turn off most of the stuff that makes vampire drain noticeable. The big deal in the extreme circumstances you described is going to be pack heating. The vampire drain isn't going to turn your CT into a paperweight in a couple of days of sitting still.
The driving conditions might be so bad though, that 150 miles in and 150 miles out may be too far depending on how rough and bad those conditions are to make it in and out with a 500 mile range charge. It won't be the aero that you are worrying about - I expect you're driving 10-25ish (20 is about the peak for efficiency on flat/dry pavement). The problem you'll have out there is rolling resistance. If the road is reasonably flat and packed gravel, then I wouldn't expect much of a hit. If it's a barely defined dirt track, with potholes or mud up to your axles, then I'd expect the rolling resistance to be so high that 500 miles of range won't get you 150 miles in/out.
There's a lot of variables that matter, and that tells me that for the circumstances you aren't easily within an EV's capabilities yet.
One idea - consider an EV for your daily commuter and other more routine transportation needs. Part of the idea here is to start getting to know how EV life is different from gas/diesel life, and start getting your own personal idea of what normal is, and how normal varies under different conditions.