I've located the files in:
but now I am unsure how to actually open them and view the content. "Open With" Notes app does not seem to work
You could use an app like https://www.sqlitepro.com/ to open the SQLlite database. But are you sure your data is there? At my system there is nothing in it.