Prostitution being acceptable is not a social norm except in one small fraction of the population. Most people still view it with revulsion.
It's of course generation and location dependent, but I don't expect any people in my circles to have a negative view on it.