Here's one way I could see this killing Comcast, even in major cities:
As a homeowner, you by a small box which lives under the eave of your roof. The box has high-bandwidth, low-latency satellite uplink to SpaceX which gives you your internet.
The same box also has a terrestrial wireless repeater which serves the local neighborhood. Internet is available through your "tower" to neighbors and passers-by. You and SpaceX split the revenue from the traffic.
Basically, it's like a solar roof, but for internet. Photons/bits rain down from space onto your roof, and you sell the energy/bandwidth back to the local area for a price that amortizes your investment.
In areas very poorly served by internet, or with very poor broadband choices, there could be an especially strong financial incentive to be the guy on your block with a SpaceX repeater.
It would certainly scale a lot better than every house having an uplink-- customer connections are instead concentrated into micro-regional nodes. If there's a node in your area, you buy internet from them. If there's no node around, you invest in becoming one.
This could drastically decentralize and cheapen internet across the globe, if done right. It could be extremely disruptive to telecoms, and profitable for SpaceX.