Most importantly, the question "How effective is aikido in self defence?" is far less important than "How effective is the aikidoka at self defence?
Absolutely. It's the martial artist, not the martial art that determines how well you will do.
Living in NZ, I tell people that if they really want to protect themselves...take a defensive driving course. More people die on our roads than through other violent means.