I'm looking to off-road, I was wondering if this shaft can handle well in sand dunning, rock crawling and muddy terrains

Absolutely. This is what we would and do use as well. A great choice made from strong DOM tubing. We would not expect any issue.