Where is the data collected by the WebRecorder's ArchiveWeb Browser Extension stored?

They’re stored in IndexedDB. See this post for details on exactly where that is on your machine!

For the standalone app, (on macOS) the answer is similar: username > Library > Application Support > archivewebpage > IndexedDB