One thing to consider is that it may not be that the Roku is incompatible with that TV, but rather that the TV itself has an issue with its HDMI port.
Alternately, it could be you have a defective Roku device. Maybe the Roku Streambar didn't get a proper update?
My Streambar (9102) has worked flawlessly, but it's on a newer TV. I have a family member with a Streambar Pro (9101) on a similar Bravia TV from around the same time (mid-late 2000s) and there has been no issue with it whatsoever.
There are enough things that could still be wrong. Troubleshooting to this point hasn't ruled anything out.
Do you have another Roku device, apart from a Roku TV? Do you have any device that was built by Roku, apart from the problematic Streambar? (Roku TVs aren't built by Roku; Roku only licenses the software to different manufacturers.) Do you have access to another Roku device? Friend, family member with a Stick, Express family, Ultra, or something else? Anything that could be brought to your Sony and connected? If multiple devices don't display on it, that leans to the Sony itself being the problem.
Perhaps others will have other suggestions to rule certain things in or out.
Roku Community Streaming Expert
Note: I am not a Roku employee.
If this post solves your problem please help others find this answer and click "Accept as Solution."