What I don't understand is why nearly everyone switched when it comes to temperature.
For the other metric units, such as meters and grams, the new units had a clear advantage over the old: decimal based subunits.
That was an advantage that you could not simply add on to your existing units without making a total mess of things.
This does not apply to temperature, because we very rarely use subunits with temperature.
Furthermore, the other base units are frequently used together in very commonly used derived units. For example, force is length x mass / time^2, pressure is mass / length / time^2, and energy is mass x length^2 / time^2. Those are all important enough that they have their own names.
There are no commonly used named derived units that are based on temperature (and I can't actually offhand think of any named derived units based on temperature).
In short, a government can make a pretty good case to its citizens to switch to meters and grams, despite the costs of dealing with that obsoleting a whole bunch of existing rulers, scales, and written records, because it is actually a better system.
But as far as I can tell, meter+gram+F would work as well as meter+gram+C, so it is hard to make a good, let alone compelling, case to your citizens that it is better. All they've got is "everyone else is doing it".
For meters and grams, "everyone else is doing it" might be good enough, even if meters and grams were not actually better than the old system, because of international trade.
People choose dimensions and weights of goods to come out nicely in the units they use, and they want to buy goods with nice dimensions and weights, so if you are trading internationally in goods, you have to deal with length and mass units of your trading partners.
Length and mass cross borders in trade.
For temperature, that is generally not the case. If I'm importing stuff from, say, France to the US, for almost all goods it does not make one bit of difference if France and the US use different temperature units.
Temperature does not cross borders in trade.