Will Etsy order status automatically update?

Yes,

When your order is shipped (Order status is Fulfilled), the tracking number and carrier and order status of the order will be synced to your Etsy store management.