Mayor Adams joined union workers Wednesday to rally support for a proposed affordable housing development in the Bronx that has attracted stiff opposition from local residents — including the area’s Council member, who holds major sway over whether the project will come to fruition.