If you open up the finder and navigate to /Users/yourusername/Library/RenPy you should be able to find the folder. Alternatively if go to the "Go" menu and choose "Go to folder" you should be able to paste the location ~/Library/RenPy/ and go there automatically.