modem = moulator-demodulator
Even in the cable/dsl world it still does change the incoming signal(demod) into something it can use, and change the outgoing data (modulator) into something that can be transmitted over a long distance.
No it doesn't. A modem modulates a digital signal into an analogue one so that it can be sent over an ordinary phone line and via an analogue exchange (and demodulates the analogue signal it receives). Cable and DSL connections are entirely digital.
However, because the function is the same (ie it's a box that connects you to The Internet) the name has carried over to the newer devices. Technically most of them are routers, but the distinction isn't really important.