No, not stupid. There are no stupid questions if you honestly had no idea. Look at a sand boa. Small shovel nose that goes almost flat at the end for easy burrowing so no sand gets in the mouth with heat pits so small you can barely see them. They are designed to live in a sandy/dirt/clay type area.

Ball pythons wouldn't fare as well in the long run. Plus, it is very dry normally and would make for terrible sheds but if you got it wet it would be clumpy. What a mess.