If you delete a photo from Facebook, it will never be recovered. Removing a tag from a picture is a little different. The photo still exists, but it will no longer appear among your photos. Those who are friends with you but not the person who posted the photo probably won't see it either. However, the photo will still be on Facebook. Someone could tag you in it later unless you change your settings.