I can understand the frustration your are feeling R. McKay. This is indeed a worthy certification which requires an awful lot of preparation. Unfortunately sometimes that means that we fall short of our goal. But keep in mind the bigger picture. This is one score on one day of your life. It doesn't reflect your value as an administrative professional. That is displayed every day on the job.
While I do hope you will sit for it again, especially given how close you were, it's ultimately a very personal decision on whether to leave that bucket list item unchecked or not. Only you can make that final determination.
There are resources out there for you though, if you choose to try again.