@markbookpro it is absolutely not necessary to replace your logic board; this is very easily repairable for someone who does microsoldering repair. Either by replacing the broken connector, or worse case scenario if replacement parts are nowhere to be found (happens sometimes), connecting the cable directly to the board. We’ve done it before and it is pretty straightforward.
Even for someone who is not a microsoldering technician, but good enough with a “macro” soldering iron, it can be pulled off. Provided your hands are not shaky and you do not knock adjacent components off.
If you don’t want to venture with this repair, you can mail it in to a reputable micro soldering tech. They can fix it and even replace corroded components if any are to be found following the liquid damage it has suffered. Some of them contribute to the forum here like @oldturkey03 said. Depends on where you are located.