I would say that no, modding is not an essential part to a game’s success. However, having a dedicated modding community proves in several titles that it boosts player count and overall enjoyment.
Anytime I’ve played a game that I enjoy at a vanilla state and then added mods after playing for a while it adds another layer of value to the game and it heavily increases the replay value.