Yeah not really. It generates money for the city to run their programs without raising taxes on residents. Those properties aren't being purchased by anyone who can't already get a home.
I think the revenue is probably overstated in the long run as people will find a way to offload the properties except for a select few who will consider a cost of doing business.
Also a great marketing move by Mamdami in terms of walking his talk.