Apple ID Security in Smart TV

“Never Require Password“

Then any user on that TV can one-click-buy content, even accidentally. If you are fine with that, then go ahead and enjoy the easy life.

Maybe my password is unsecured in the Sony’s Apple TV App … ?

The Apple ID password is only known to the Apple TV app on that device; not readable anywhere; not known to Sony or other apps.

This Apple Support article has information about signing into the app initially. As well as how to reset the app, when you eventually get rid of the tv.

Get the Apple TV app or Apple TV+ app on your smart TV, streaming device, or game console - Apple Support

There is also an option to sign in using your phone.

“Sign In On Mobile Device: Use your phone's camera to scan the QR code on the TV screen. Then follow the instructions on your mobile device.”

Since the app itself is developed by Apple this is unnecessary but may be possible for added security. Using app-specific passwords - Apple Support

I hope this helps.

Verify that the setting is on that requires the password (again) for new purchases.

Set password requirements in the Apple TV app - Apple Support