How does iphone treat old sms messages? Are they ever deleted automatically, if so how? What about picture messages?

Not deleted automatically.

iOS messaging database is limited to 15 MB of storage, which is about 75,000 messages. If you have updated and your iPhone displays the following message:

Maybe the storage limit was increased with iOS 6, but the point is messages are not deleted automatically which was your question.