Sorry but I don't understand the question - why would there be a "headphone in" socket? Headphones are output devices and not input devices. There could be a microphone in socket on your Sony radio cassette and you could use that but the difference in levels might give you distortion as headphone signal levels are much higher than microphone levels. And even then I am not sure you could directly hear the output without recording it to tape first.
Google Home Hub review