Hello,
Just two days ago today 8/26/2023, I have an apple tv box and when I go into apple tv app, it displayed 1: my family members accounts (missing my movies and tv shows) or 2: It would just get stuck in the spinning loading wheel. and 3: Got a message "You have not purchased any TV Shows or Movies from the store".
I have contact apple support ten times and one person said that I needed to send my apple tv box in so that apple support can load a new OS onto it. Today, I bought a new apple tv and ran into the same issue.
Resolution that i have not found out there but wanted to provide you that it can be helpful as it has resolved this issue on both apple tv boxes of mine.
On apple TV box iOS TV 16.6+
Settings>Apps>TV: 1: Clear Search History, 2: Clear Play History.
Then Next,
Settings>Users and Accounts: Select your apple ID, mine was listed as default user>remove user from apple TV
For me, I went into the iTunes>Accounts>View My Account: Look for "Account Access" and select the "Manage". From there, I saw Apple TV+ and select "Sign Out"
After all that, I went back into Setting>Users and Accounts>select default user and signed in.
Then, I closed the apple tv app about once or twice, then all my TV Shows and Movies showed up again for me. This has worked on both apple tv boxes.
Is that what you are having problems with?