This is awesome news, and is really going to enable some powerful stuff (and it'll be cheap! SIP/VoIP is far cheaper than using your minutes on a traditional phone plan). For folks who haven't worked with Twilio before, one of the slightly obnoxious parts is TwiML, their proprietary markup language that describes how to make, route, and respond to telephony events. It's not difficult to work with, but it's nonportable and irrelevant if you're not using Twilio.
But now, by exposing the underlying SIP streams, Twilio is opening the doors to a broader range of applications (commercial PBXs, enterprisey telephony folks, etc.). Unfortunately, it looks like you still have to use TwiML to get the job done, but all the custom stuff can be done on your side instead of having to port that to TwiML.