A support article explains further about how you can “Set a local contact picture for someone in Google Messages: You can choose to display your contact’s profile picture in Google Messages.

Google Messages users can now replace a contact's Google account profile picture with one of their own choosing ... but if one of your contacts did this, the profile photo you chose for them ...