The internet connection is only required if the drone is incapable of broadcasting its own local ID signal. This will not be a problem for the kinds of drones that have practical uses in remote areas.
Also, as with many other drone regulations, this does not apply to lightweight units.
From a quick skim of the unpublished document it seems like a compliant transmitter could be built from hobbyist parts for under $100 and weighing a few ounces. Commercial options should have no trouble beating both of those numbers.
It seems like those with drones at the absolute bottom end of the "registration required" range could be limited by this but as long as your drone could handle having a basic flip phone attached to it you shouldn't have trouble with this.
You're raising valid points generally but read 89.110 for Standard Remote Identification. If internet is not available the drone must broadcast the information elements directly. This does preclude 'limited remote identification' UAS from operating without any local internet and of course no remote identification UASes will be stuck in the FAA sandboxes.
Definitely some rough edges in this that will hopefully get eviscerated in public comments.
* Drones are only ever as reliable as the internet connection.
* Drones cannot be used outside of locations with internet.
* A small number of centralized servers are given authority over a large number of drones. This is a very real risk.