Reading that and moving past the ZOMG NANNY STATE bullshit, it's no different to what happens now. If a child is thought to be at risk then someone has to be allowed access to view the accommodation they're living in, and all this new guidance (and that's all it is, guidance not law) will allow them to do is to pass comment over things like grates in front of gas fires, bottles of bleach kept in cupboards and not on the side etc, basically common sense stuff any decent parent will be doing anyway. If you live like a pikey in a shitty council house full of rubbish and crap that's blatantly a death trap for kids, then I'd want the appropriate services involved and doing all they can.
Honestly, sometimes the Times is as bad as the Mail for this kind of thing. And to think people mock the Sun for crap journalism...!