The US president stopped short of issuing new threats, but called Thursday's drone attack "foolish."