The goal of repairing the destroyed gate in the LEGO set is to access the Nether, an exciting and dangerous dimension in Minecraft. By mining the obsidian rocks and repairing the gate, players can help Steve continue his quest and experience new adventures in the fictional world of Minecraft.