A major argument atheists make is that its absurd to teach young children who can barely count to 5, about God. Do the atheists have a point here?
Since Atheists do not judge the world, and since Atheist has no standard for morality apart from God, and since Atheists hate God, the Atheist is not one to consult about teaching a child about God.
It is far more absurd and unloving to not teach a child about God, to teach them the fantasies of the Big Bang and Evolution.
Should young children be taught about God when they probably can't even understand anything in the bible?
This is not a fair assessment. Children understand far more than we give them credit for. Yes, there are hard things to understand in the Bible, but the fundamental truth of the Bible and God can and should be taught to children. To withhold the truth from a child is very unloving.
Also can't this lead to the child eventually rebelling once they leave home for college, and ending up an atheist?
Not at all. It is far more likely that a person will become an Atheist by not hearing or knowing the truth of God, because they have formed an image of God based on error and misinformation.
I personally kind of feel uneasy about the whole thing, because it leaves children with way more questions than their parents can answer.
Parents can never answer all the questions that children have, since parents are not omniscient. But if a hard question comes up about the Bible, that is why you seek help from your Pastor, Elders and other brothers and sisters in Christ. God never asks parents to operate in a vacuum.
And causes children a lot of distress, why should a 5 year old be afraid of going to hell?
If parents are only teaching there children about Hell, yes, that can cause a lot of distress. But if you are a Christian, you teach the child the whole counsel of God. God's love, grace and mercy are meaningless when you do not teach the child of God's righteous and holy wrath against sin and how the fundamental nature of man is to sin.
I think there needs to be a minimum age where a child can consent to learning about the bible and God.
For your family, that is your choice, and you will give account to God for why you withheld the truth from them at an early age. But you or anyone else does not have the right to force my wife and I when we choose to teach my children about God.
Because at such a young age I think it does more harm than good personally, especially from my experience, especially with older siblings or parents who threaten you with hell if you don't clean your room or something.
Again, parents are to teach the whole counsel of God, and not abuse God's word with threats to modify a behavior. It is right to fear God, but it is far better to love Him because of how amazingly kind He has been and is to us. God does not owe rebel sinners anything.