Surrendering your current green card would not be a basis to deny a future immigrant visa petition for you if you are otherwise eligible for an immigrant visa. However, getting an approval is a long process and there is no guarantee of success. You likely should look into keeping your current green card.
An applicant for a tourist visa is not supposed to have an intent to come and live in the US permanently. Persons with US spouses and children likely cannot prove to the US consular officers that the persons do not have the intent to come and live in the US permanently. In fact, your post shows that you do have the intent to come and live in the US.
You can review your specific facts with your attorney to see what your legal options are.