It's my understanding that President's in the past have said they would abide by the terms of treaties that have been signed and not ratified. However, this is pretty much the President just saying they will direct executive branch agencies to abide by the terms of their own treaty as long as it doesn't conflict with existing law. It has no legal standing. So Obama couldn't, say, direct an agency to create a national registry and then use this unratified treaty as a defense in court.
The shooting would start before the court heard the case.
As we have seen in the past, activist courts (9th Circuit) and judges don't confine themselves to the constitution or written law when presiding over cases.