> the slow and unproven trickle-down effect of market-rate housing
Slow and unproven? Supply and demand is the most reliable law of economics. Cities like Austin that are building market rate housing are actively seeing affordability improve.
Furthermore, even if it wasn't sufficient, abundance YIMBYism would still be helpful and necessary.