Yes it's still there and yes it's still good.

However, you can't just walk in. You either need to be a member, or need to be the guest of a member.

If you're the guest of a member they'll need to sign you in, and you'll have to present your original ID at the door (not a copy) and pay a QAR50 entry fee.

This is being adhered to strictly these days.