I think you might be getting too hung up on external goals. You can absolutely write an apathetic character who is interesting, but they won't have goals that are opposed by their environment, thereby creating tensions. With an apathetic character, the conflict is actually internal - character vs. self. You have to answer the question "Why is what the character wants not actually what the character needs?"
For example - your own character. You say this character wants to be left alone, doesn't want to do the prophecy, doesn't want friends, etc. But you ALSO say that this character is afraid of forming attachments (because he's afraid to be hurt, possibly? Or afraid of the responsibility and how that would make him feel motivated to take on his role in the prophecy?) and that he ends up forming attachments fairly quickly, which to me suggests that this character NEEDS attachments, while he states that he WANTS none. There's your conflict.
This kind of a reluctant hero is very very popular. Bilbo Baggins in The Hobbit continuously acts like he has no choice in the matter of going on this journey, but we as the audience can see that he actively chooses the dangerous path every time because, despite his loud assurances to the contrary, he NEEDS the adventure. Sakata Gintoki in Gintama acts like he doesn't care about anything or anyone, that nothing matters to him (because of his past, and because of what he's lost) but as the audience, we see him go out of his way to help people to the point where he basically adopts an alien girl (even though, based on his past, she should've been a mortal enemy) and puts his life on the line for the benefit of others.
The trick with these characters is that you need to establish this conflict right away. You can't have your character floating about loudly complaining about the plot without showing that they actually don't really mean it, because your character then just primes the audience to hate the plot too.