Unfortunately, the data did not appear even after rebooting. Contrary to some posts, the Google Files app does not show folders in /Android/data. Using ADB, /Android/data/com.mictale/gpsessentials/files/databases/showed a 94KB file, when it should be 390MB. If I create a Waypoint, it is saved and gpse.db increased to 303KB.
I did find the converted gpse.db in /sdcard/Android/data/com.mictale.gpsessentials/files/export/databases. If I manually copy the export/databases files to databases using ADB, GPS Essentials now sees all my streams and waypoints.
I have some other projects to work on but will try to reproduce the issue on my wife's Pixel 7.