You're mistaken about the reasons why solutions are unpopular. Have you actually talked to the most active NIMBYs who oppose new housing development? Most of them are barely aware of affordability and home prices. They have lived in the same neighborhood for decades and intend so stay there until they die so prices don't impact them at all. Instead they are concerned about quality of life issues: traffic, parking, noise, petty crime.
Or just straight up bigotry. They love to claim apartments increase crime, but then act like row houses are somehow different.