So I definitely think Starlink could compete in that market. But more as an equal than as the only option.
If SpaceX is going to make huge returns on starlink, they will have to be price competitive with at least the DSL providers that are in many rural communities. Many of your remote rural areas in the US have at least 6 to 10mbps for ~$60 a month, and that's plenty for most casual users. Even for video streaming.
And that's now, when there's still large urban areas in a lot of countries on DSL. Once that DSL is phased out, rural areas are going to need better sattelite options or expensive long stretches of fibre to not fall behind the curve.
The main issue for rural satellite access is no longer bandwidth or even data caps but latency.
And if you have DSL in rural areas, count yourself lucky.
For rural areas, there are wireless ISPs for rural areas here in Colorado where you put an antenna on your roof. You get line of sight to an antenna on a nearby mountain for internet service. I don't see how Starlink can possibly compete with that on a technological or cost basis. It seems like most of the western US could have service like this for many rural markets, if it's not already available.