profile picture appears in gchat but nowhere else
When I send SMS to another phone, it's not sent as my Google profile, eg. example@gmail.com, but as my number, eg. +123456789. 

If you add your own number to your contacts, and then add profile picture, you will see it in SMS chat.