Judging by https://howtheyvote.eu/votes/189270, the outliers who seem to want this, would be France, Hungary, Poland and Ireland, all other countries seems to had the majority MEPs voting against it.

The countries are free to repropose similar things through the council (basically the representatives of the ruling party in each country), but the MEPs are free to strike it down. The MEPs are elected through PR in each country so often have broader representation than the council.

It’s more complicated than that. MEPs do not represent countries, so you can say that most MEP from $country were for or against, but that would not necessarily be the position of the country’s government. For that you have to look at what happens in the council of the EU, which is composed of government ministers.

It is not exceptional for most MEP from a member state to be in the opposition at the national level, particularly in contexts where it is seen as a protest vote. Turnout is usually low for European elections, so they tend to swing a bit more than national elections.

It's way more complicated. For instance according to this vote Denmark is overwhelmingly against it. However Denmark most recently was the country that pushed heavily towards this, in fact, under Denmark's leadership the whole thing was revived last time around.

If you look at local politics and news they are all lobbying massively for it (or some people do). The reason is usually "for sake of the children". Parents in particular are heavily in favor of chat control.

Hungary can be explained by Victor Organ's desire to spy on the opposition by any means necessary.

France has had really strange tendencies lately, e.g. when they arrested Telegram founder.