I think as of now you have to have an app that will do that, you can't do it from the pictures itself (once iOS 5 launches you'll be able to choose a pic and choose send to Twitter!)
yes, there is no way to post it directly form sms... you need to use a twitter application that uses an image API to post it on an image hosting site such as twitpic