I am curious if the json data can be read into Ren’Py, which is based in Python. Can it be done?

Python does have functions to parse JSON files, so it shouldn't be a problem. See more here: https://www.w3schools.com/python/python_json.asp

You can download an example exported file and check it out yourself (button at the bottom of the main page).