This is the second big Paris referendum on transport this autumn; a rule banning the free-floating rental e-scooters was passed very recently as well (they were a nuisance to pedestrians, and the evidence suggested they were mostly replacing walking journeys rather than car journeys).
It looks as though this SUV thing will be passed, because the right to vote is limited to those who live in Paris proper, most of whom have no car or only a small car. SUVs are popular among suburban and rural dwellers who live in the outlying regions and who may currently try to drive into Paris by car…. But they won’t have the right to vote on this, so will not have any opportunity to express their own opinions.
Personally, I think driving any sort of car into a big city like Paris is pretty insane. Use a parkNride and the metro etc.
As the UK gradually starts housing more and more people in former-brownfield sites in core urban areas (due to a combination of the housing crisis plus the fact that suburbanites and countryside dwellers get mad when anyone tries to build extra housing near them), we may start to see some similar interesting shifts here, especially if a Labour government also brings in a greater level of devolution for cities.