Why are you torn? You need the dog to do something specific, it isn't capable of doing that, and further more you can't provide the care it needs. Attached or not, the dog GOES before it becomes and absolute NIGHTMARE to re-home. That's just common sense, IMO.
This is why, if you need a dog to do something specific, you go through the proper channels. I sincerely doubt you had any legit help or advice when choosing this dog or you wouldn't have chosen it - WHOEVER told you these dogs make "great ESAs" clearly didn't know what they where talking about. High drive herding dogs RARELY make good ESA or SDs because they are so high drive and difficult to maintain.
Any animal can be an ESA - so if you are disabled and looking for a dog to help with that disability you mean SERVICE dog which is NOT the same thing. And, again, if you where going through the proper channels you would know this.
Is this dog even prescribed by a licensed medical professional specifically for your legal disability? If not, then you have NEITHER an ESA or SD. Just a pet. You need a PRESCRIPTION for either to be legal. If you're hoping for a service dog then the dog needs to DO something to MITIGATE your disability, IE must perform a TASK that is NOT something a dog would normally do (IE was specifically TRAINED to do it.)
Either way this dog is NOT a good match, regardless of what you want it to be, and also DOESN'T appear to be doing what you need it to. WHY keep it and make it miserable? It's just going to develop serious behavioral problems if it's needs are not met, and you're never going to be able to self-train it.