God was manifested in flesh [TR - KJV : 1 Timothy 3:16]
Jesus Christ is come in the flesh [1 John 4:2 KJV]
That God is manifested in flesh and that Jesus Christ is come in the flesh is not at all the same as to say that 'God is a man'.
The scripture, in the original Greek, is exceeding careful in this aspect and although I support the KJV yet still I have to find fault with it, where, on occasion, it adds the word 'man' in connection with Jesus Christ where neither the word anthropos (humanity) nor aner (an identifiable individual man) nor arrhen (a solitary man, a bachelor) appear in the original, the correct translation sometimes, for example, being 'one', not 'man', as in Hebrews 3:3..
Thus also, the expression 'God was made man' or 'God became man' (which I have heard and read) are not scriptural. God was not changed into humanity.
So the text in Hosea 11:9 holds good in the New Testament, for 'manifest in flesh' or 'come in flesh' do not at all have the same meaning as 'I am a man'. Thus God says 'I am not a man', quite rightly and quite consistently.
But the manifestation was promised from the beginning. In Eden, God promised that the seed of the woman would bruise the head of the serpent, that is to say, from above, in ascension, and that in humanity, Genesis 3:15.
Thus the Arche, the Principality, the anointed cherub on the holy mountain, Ezekiel 28:14, is bruised by the Lord, manifest in humanity.
And manifestation is seen again in the three men who came to Abraham and he said, My Lord, and bowed himself to the ground, Genesis 18:2.
And again, when Jacob wrestled with a man to the breaking of the day and he would not tell him his name, but touched his thigh and the sinew shrank, Genesis 32:24.
And again when Manoah and his wife saw the Angel of the Lord caught up in the flame, Judges 13;20.
An yet again, when Moses beheld the Angel of the Lord call out to him from the manifestation of a bush that burned and was not consumed, Exodus 3:2, a picture of deity manifest in humanity, the humanity not consumed by him who is a consuming fire.
And yet again when the king saw a fourth in the furnace and he was like unto the son of God, Daniel 3:25.
These manifestations heralded the coming of the Son of man, that is to say - The Son; of man - who would 'come of woman', Galatians 4:4.
It was ever intended.
And it is so.
But without contradiction, for God is not a man. But God is, in the person of the Son, manifest in flesh and come in flesh and come of woman.