What happened to the army officers who attempted to form the Society of Cincinnati?

They succeeded.

Its members have included many distinguished military and political leaders in the history of the country, beginning with 23 signers of the United States Constitution. The Cincinnati is the oldest military society in continuous existence in North America.