When people talk about small talk, they're often talking about their experience with small talk and not about small talk as an art form. You see, most people who engage in small talk do it insincerely without any rhyme or reason. The quality of conversation is low and you're left wondering why this person even spoke to you in the first place. However, one should not allow experience to cloud one's judgement. Experience is supposed to enrich your perspective, not restrict it. If you don't allow such experiences to restrict your perspective, you will probably start to recall some amazing conversations you've had that consisted entirely of small talk.
Personally speaking, the best conversations I've had were a mix of small and deep talk, but mostly small talk. Something like 70-80% small talk and 20-30% deep. I find it sad that so many intelligent people allow themselves to believe that small talk takes no skill and when they engage in it they don't even try. They will be semi present and devoid of enthusiasm as they meekly ask you what the weather is like. Their "I don't give a damn" levels are so high, they will sometimes ask you this when you're outside baking in the sun. It's so robotic and far removed from humanity that the experience leaves a foul taste in one's mouth. On the opposite end, an enthusiastic and skilled conversationalist can small talk for days and you will crave their company, wondering when you will see them next so they can finish that story where the tortoise spiked the hare's drink before their race.
As an ENFP, my mind doesn't perceive the finer details until someone points it out or I focus really hard, then I'm all like "oooow". Seeing the finer details is necessary for small talk because it's the finer details in a seemingly unimportant topic that makes it fun to talk about. I'm actually quite good at small talk but I have to put in a lot of conscious effort because unlike deep conversation topics, interesting small talk topics don't come naturally to me and I end up spending more time in my head thinking of topics than I do instinctively in the moment, which kind of sucks. So when I'm the one leading a conversation, it will either end in 15-30 mins, or it will get deep, otherwise I get mentally exhausted. However when I'm not the one leading the conversation, and my convo partner knows how to small talk, it's a dream. Good small talk recharges you without draining you.
On the point of engaging in small talk with people you know. I spend hours at a time talking with my mom and most of our conversations consist mostly of small talk. 2 of my cousins love to small talk and I enjoy their company immensely. We've pulled many all nighters talking about meaningless crap. The thing is both of these cousins and my mom are all really good at small talk. In contrast to the people I described earlier, they are enthusiastic, not overly polite, unpredictable and have an eye for the finer details. They don't just blurt out the first meaningless thing that pops into their mind. They choose meaningless topics that are interesting and funny.
To answer your question: ENFPs love small talk but need someone with an for eye the finer details to lead the conversation, and sadly, such people are scarce.