One of the biggest fiascoes of Barack Obama's presidency occurred when he warned the Syrian government that any use of chemical weapons against rebels would breach a "red line."