Can an overstaying tourist here in the US apply for adjustment of status?

No. Unless you have gotten married to an American citizen or permanent resident. If married to a permanent resident you will probably have to return to your home country first and contact the US embassy there. The alternative is to wait on Immigration reform.