A bike path through a dense part of town like that isn't there to be pretty, at least not mostly. It's there to be a separate ROW for bike travel, to make bike commuting etc feasible. 1.9 miles of which some part is ugly to complete a route from _Bedford_? If I were riding in from Bedford, I'd say it's worth it.
The one thing that bothers me about the plan as shown in the video is that there is always a fence between the trail and whatever's next to it, even when that's the backs of houses. I guess they figure people will want to feel like their yard is still as private as it can be next to a trolley line and a bike path, but a chain link fence won't keep out voices and will mean that none of those abutters can just hop on the train from their own yard. I ride an unfenced trail to work (in Terre Haute, IN, and part of the way it goes right alongside a complex of townhouses, no fence, lots of bikes locked up on back porches ready to ride.
Bike commuting and transit are good partners, too, b/c lots of bike commuters turn into transit passengers in bad weather.