Yes it will. It might not help as much as cheaper housing, but it will help. Any increase to housing stock should lower prices overall. For example, building a luxury apartment building that adds a few hundred expensive units to an area will apply a bit of downward pressure on other parts of the housing market.
There might be a problem if new luxury spaces were too big, but in my experience they are still very small units. In my neighborhood the new luxury buildings have smaller units than mine. Mine isn't luxury just bcause its older and doesn't have a new kitchen.
In big expensive cities I'm not even sure how you'd build non luxury. I think you'd have to make it shitty on purpose.
If you think it's a good idea then start a development company, petition the city for permission, and raise money.
Further, housing is not a purely elastic good. Many luxury/high end places would rather a unit stay vacant for longer than to rent it out at lower prices to someone who might be an "undesirable".
Well, for starters, "affordable housing" is usually used in the context of adding housing. So it's generally already part of the discussion. And secondly, it's not just more, but what kind of more housing. More, yet expensive housing won't help, so "more" is necessary, but not sufficient.