I would choose based on the user-interface.
Airtable for sure - especially because the UX is very similar to that of a spreadsheet which means that it requires less explanation and learning to use.
Notion - I've used it before and while the interface is great, I'm not sure that it really works as a good CMS. (This is a personal opinion). Also, navigating Notion (in comparison to Airtable) requires time.
Obsidian - I've not tried using Obsidian as a CMS but as a note-taking app. Again figuring out how to use it is quite a task - and this was to just to take notes. Also, their phone to laptop sync is terrible (iOS) and the Airtable app is brilliant - so points to Airtable again.