Hi Sarah,
The sorting in Ragic is for your own only. When publishing to the web, system fetch the data from the sheet, but not from a specific user’s view of the sheet. Which means the sorting won’t be applied cause it’s for yourself only.
If you would like to have the result with sorting applied, you will need to set up a “fixed filter” with this sorting applied.