If I understand correctly, it sounds like you are running into an issue with the way permissions work.
It sounds like you want:
An anonymous viewer of your shared view link to be able to click on an “Area of Expertise” card, and then click on the name of a faculty member listed under that “Area of Expertise” to see information from the faculty table about that faculty member.
If that is correct, then the reason this does not work is because of the way permissions work on shared view links. When you share only that view, Airtable assumes that you are doing so because you do not want anonymous viewers to be able to see anything else in your base besides what is contained in that view. Information about faculty members beyond their name exists in a table outside of the one you are sharing - thus Airtable assumes you do not want anonymous viewers to have access to any data from that table. In other words, Airtable cuts off anonymous viewers of the shared view from expanding the faculty record you have linked because doing so would give them access to areas of your base that you have not shared.
This is a (seemingly) necessary security and permissions feature, not a bug or an issue with the way you have it set up. Unfortunately, the next step up in permissions is to created a shared link to the entire base - there is nothing in-between; and this is seemingly due to technical reasons with the way the software is set up. Alternatively, you could try to find a creative way to pull the data you want out of the Faculty table and into the table you are sharing by using Lookups and Rollups - it may not be easy, and may take some careful thought, but it may be possible.
