Aside from the question about whether it is wise to have insurance, sometimes AOPA insurance is the way to go, sometimes not. Many people have found better deals with other companies. Don't assume that just because you are a AOPA member that their insurance quote will be the best.
Remember they may be pushing their insurance as a member benefit, but in reality they are selling it because the organization receives the benefit i.e. cash by marketing it to their members. Not necessarily a bad thing, after all, since AOPA is an advocacy group, but that doesn't mean I'm going to pay higher insurance rates just to support AOPA.
I'm rather sour on their member products anyway. None of their insurance carriers (as of earlier this year) will insure an Alaska aircraft. Period.
If you wreck a rental aircraft, the FBO WILL COME AFTER YOU for the deductible, which can be upwards of $10,000. The insurance carrier probably won't subrogate unless there is gross negligence. Renters insurance is very inexpensive. So the only question is, is it worth self insuring, or paying a small amount per annum to avoid having to worry about it? That is always the eternal question about insurance.
Also remember legal liability, which is the other large part of insurance. Prang an airplane on a botched go-around, and you will likely only be out the FBO's deductible. But what if instead of bouncing off a tree you landed on a minivan full of kids going to school, or the newly-restored Beech Staggerwing taxiing for the runway?

Or what about the passenger/buddy who
says that he won't sue you in case of an accident, but is suddenly facing $50K in medical bills...who is going to pay for your lawyer?
Having 20% of your wages garnished from your paycheck for the rest of your working life would have paid for a lot of insurance. Something to think about. Don't get me wrong I'm not an insurance salesman or anything, but aviation is a litigious field, and IMHO not the place to scrimp on insurance.