Firstly, you have Row Owners applied to your email column. Row Owners is a security feature that prevents anyone from viewing data that they don’t “own” (the data is not downloaded to the users device)
Secondly, you are viewing the data as “anyone”. When you do this, you would see the same as somebody that is not signed into your app. In this case, the expected result would be that no rows would be visible.
I think the first thing you need to do is decide is if you need Row Owners or not. If you don’t, then the easiest “fix” will be to simply remove that from your Email column.
