Hosea 4:11 Whoredom and wine and new wine take away the heart.
Take away the heart does not equal getting drunk on alcohol. The context is how God is against this people because they reject that there is a God. They eat, they drink, they have their full. They live as they want with no consideration that there is a God. New wine is found in the clusters. That's grape juice. Old wine, or fermented, spoiled wine is not found in the clusters but through a fermentation process.
New wine can be made by squeezing a bunch of grapes into a cup according to the below verse.
Genesis 40:11 And Pharaoh's cup was in my hand: and I took the grapes, and pressed them into Pharaoh's cup, and I gave the cup into Pharaoh's hand.
Take away the heart does not equal getting drunk on alcohol. The context is how God is against this people because they reject that there is a God. They eat, they drink, they have their full. They live as they want with no consideration that there is a God. New wine is found in the clusters. That's grape juice. Old wine, or fermented, spoiled wine is not found in the clusters but through a fermentation process.
New wine can be made by squeezing a bunch of grapes into a cup according to the below verse.
Genesis 40:11 And Pharaoh's cup was in my hand: and I took the grapes, and pressed them into Pharaoh's cup, and I gave the cup into Pharaoh's hand.
The Lord says, “Wine, both old and new, is robbing my people of their senses!
Hosea 4:11 GNT
https://bible.com/bible/68/hos.4.11.GNT