More units, even luxury units, are good for everyone, even lower income people. The people trying to advocate for lower-income people by blocking housing are making it worse for the very people they're trying to help!
However, if inexpensive apartments are either bulldozed or remodeled to become luxury apartments, eliminating inexpensive options for the lower paid. That has been happening in Mountain View and probably in San Francisco which the Guardian article directly discusses.