Drupal Commerce Total Order Weight
I believe it is generated when it's needed, and not stored. But, after looking at the Commerce Order Weight Token module, you can get the weight using the following:

$weight = commerce_physical_order_weight($order);