Is it possible to create modules which would reside on the Ethernet Modem that could respond to http requests and pass the request to the modem as an SMS message?

No, there is no way to do this in the MTXCSEM module itself.