Do you happen to know if Airtable documents rank on Google?
One of the reasons for preferring Google Sheets is because I know from experience that I come across many public Google Sheets through Google. I don't recall coming across Airtable documents, but it might be just because there are fewer of them.
I suppose you could embed it on a page (https://support.airtable.com/docs/creating-airtable-base-sha...) or use a third-party "portal" builder like Pory, Noloco, Softr, Bubble, etc. (can't recommend any, never used any of those, sorry).
Airtable also provides JSON outputs if you want to hook it up to a custom web app: https://airtable.com/developers/web/api/introduction (FYI, GSheets does this too https://www.freecodecamp.org/news/cjn-google-sheets-as-json-...)
If I were doing this myself, I'd probably just put the data in any spreadsheet or DB I like (including Airtable), get the JSON out, and then use something like MUI Datagrid to render it into a nice and simple frontend that I fully control: https://mui.com/x/react-data-grid/
But yeah, gsheets might be simpler then if there's an SEO benefit :)
This def turned out to be a lot more cost/time consuming than I expected, but I do enjoy the learning process.
Since the data will be in PostgreSQL db, I will be able to slice and dice it however I want to export it later to Airtable or other formats.
Thanks for all the recommendations!