Unfortunately no. Mnemba is a private island and you are not allowed to get off if you are not staying in the private resort there.
Instead we get off on Mnemba sandbank, very near and has the same beautifully white sand.