While I am by no means an Airtable expert, i have been playing around with it for various business functions for a wee while now.
Sounds to me like you would be better off using fewer larger tables and use views to show the different outputs you are ...