Profile picture refers to the picture a user is currently using as the main/primary picture associated with their account.
Questions using profile-picture tag might be related to third party APIs allowing for downloading or changing (uploading) these pictures. The tag might also be used for questions about developing a feature related to profile pictures.