Row Owners will only ever download rows to the device that belong to the signed in user, so even though you have a relation to that sheet, if that data isn’t downloaded, it still will not be accessible if it doesn’t belong to the signed in user.
Row Owners are used to keep data secure and private by not downloading it to a user’s device if it doesn’t belong to them. If you want that data to be accessible to other users, then Row Owners may not be a good solution for what you want.
You would need to remove Row Owners and use filters instead as long as there is no data in the sheet that needs to be kept secure and private. Otherwise like @Darren_Murphy mentioned, you can create a duplicate of the profile sheet with only the data you need and use that whenever you need it for publicly accessible data.