The attractiveness of big cities is more than just proximity of workplaces. Even if a lot of work goes remote, enough people love to live close to bars/theater/friends/etc.
I do see commuter towns getting way less popular if remote works really lifts of.