Useful, yes, but not really important. I drive a FWD (fake)SUV crossover 4 months of the year in snow in the more rural suburbs of Oslo and find myself thinking I want AWD only once or twice a winter. As somebody else said, the roughest drive we do is gravel roads.

The bigger difference might be FWD vs RWD. I do seem to see RWD cars getting stuck more (as evidenced by which wheels are spinning uselessly). For the model Y Tesla might well mimic the model 3 options of RWD or AWD, in which case AWD would definitely be the wiser choice.