Listen bro' I was a big city cop for six years before I went to work in aviation. I handed out TONS of DUI's. Believe me half of the world has a DUI, and the other half just hasn't been caught.
DO NOT go to court and plead guilty--you take it up the a$$ if you do. Get a good DUI attorney and completely explain your situation. He will go to the prosecutor and try to get it reduced to a reckless or failure to control, or perhaps even dropped with some significant community service. If you attorney has any juice at all, he will be able to work a deal for your (a good attorney will costs some $$, but that's what it will take, this is not the time to shop for bargains). If you refused to blow at the station, or tested very high, you will likely have to fight this in court.
If the prosecutor won't play ball, then your attorney will have to subpoena the BAC machine logbooks, officers training records, and get VERY specific info about the arrest, field testing, etc. You'll have to decide if you want a jury trial or a judge trial.
Having said all of this, there are plenty of pilots with DUI's. ASA has a few guys with several. Hell, the head of pilot recruiting is reported to have THREE DUI's (of course her plumbing is differren't than yours).
This is a setback, but not the end of the world. Don't listen to anyone who says it is.