I think you're being incredibly brave, and I don't mean that in a patronising way. Instead of tutting at home at the stories you hear in the news about families who struggle (and sometimes fail) to bring up their children, you're actually doing something to help them.
What your team leader has said sounds like they're just trying to prepare you and in words it's like a worst case scenario, but that's not necessarily what you're going to encounter.
Who wouldn't be scared shitless of the unknown?? I really hope it goes well for you