Okay, I'll take a crack at this. 🙂
Newbie1: Your question has two answers, a simple one, and a not-so-simple one.
The easy answer is, Based just on what you wrote (and insofar as I understand it), YES, Airtable should be able to do what you want.
The second, not-so-simple answer is, it's not possible in this forum to explain in a response to a post how to use Airtable to build a complex solution. Your question is a bit like asking (say in a carpentry forum on the internet) "I'd like to build a house that meets the following detailed requirements [insert requirements]. Is this possible and can you tell me how to do it?" Not criticizing your question or you for asking. I'm just trying to point out that it's a big question.
If you don't want to hire a developer to do the work for you, then you should just jump in and start learning Airtable. But I'd urge you to learn it a piece or feature at a time, rather than making your first base be this big CRM that you want. Learn to crawl before you try to walk, learn to walk before you try to run, and run before you try to pole vault.
Make sense?