Along rail and the very busiest bus routes is exactly where we need and want apartments that have 3-4 stories. It would make no sense to put them in the middle of single family housing because those are deserts unless you have a car, and most people that would appreciate density would love to be able to do most of their tasks without a car. That's the appeal of density.
And we shouldn't be building rail without such density, because otherwise the rail is going to underutilized. Similarly with bus routes; why send tons of buses along a route if there's no possibility to pick up lots of people?
SB827 is about fixing planning processes to allow such density where it works, and letting the sprawl stay sprawl.
Upzoning is needed and transit is the right place to start, but we have to acknowledge that this would certainly have a massive effect on many single family neighborhoods.
Park and ride is a thing. That said you need whatever the "ride" is to be cost competitive for people to take advantage of that and that's a tall order given the quality of local government in many places.
And as you ride those NJ lines, you see how many more people are supported at stops that have housing instead of parking. Parking is >200sq ft. that could be used for living instead.
A lot of my feelings are about my personal experience though, and I wouldn't want to stop park and ride if it works for enough people to support a train stop. For me, driving, then parking, then traversing a long ugly parking lot is a significantly worse experience than living there and walking out.
This assumes that "there" isn't a terrible place to live and also affordable.
Your NJ example is exactly the use case I was thinking of. It makes sense when density is uniform and job distribution is not because it's effectively a spur or extension of the mass transit line.
There is a fair amount of rumbling about upzoning single-family lots to permit mid-rise apartment buildings, i.e. SB827.