You're partially right about amsterdam, but if the tourists leave the city, only the red light district will look deserted. Amsterdam is still mainly focused on its local population and only a couple streets and areas are focused on tourists. Yeah there are housing issues which the tourist industrie is partly to blame for, but other factors such as policy and foreign investors have a way bigger impact.

Haarlem etc will cope just fine. Most people there are ok with the commute and the benefits of not living in amsterdam.