'It's an atrocity that in such a rich country we have people on the streets,' Barack Obama acknowledges