Thanks to this article, I now understand that it has to do with the length of the site URL … if the overall length of your URL changes, all the widget disappear. Odd, right?
A quick fix?
Before you do your normal find/replace action, change the URL in Settings first. Then export your SQL file. That’ll ensure your widgets stay intact.