Not just small European countries, but all European countries that do not have their own nukes, which is all except France. The issue is, they’ll have to leave the Non-Proliferation Treaty for that (except for the UK, I think), and once an otherwise respected country does that, the floodgates would be open in the world. The other problem is that such a decision would be very divisive in the European country’s electorate, and therefore highly problematic on its domestic political front. This is simply not likely to happen.
A more realistic outcome is that French nukes will be stationed in other European countries. But France is also not willing to give up exclusive control over those nukes, and the next French government could very well be far-right, and thus become as unreliable as the current US government. It’s a difficult situation.