I was one of the devs in yesterday's stream, since you stated that you wanna drop this project I've reflected more on your game to give a better feedback.
Since I'm esl I prefer ruminating on my toughts and then writing them out.
tldr, for what I'm about to write: Should you drop this project? If this is meant to be a commercial product, yes.
Imo you spread yourself too thin, but the real problem is that this game has not a strong gameplay idea. So, why it's a game to begin with?
Even with your post on the mining project, you dont start with the gameplay. Your "Concept" section it's story. For you it seems that gameplay is secondary to the story you wanna tell; that's a problem because you are not a director of a studio. You need to to actually code that shit.
There is no problem/shame to build a vn with some minigames in the middle. It can be simple, but it must always be solid.
Scope is killing you, you should design by subtraction. If you know the core of your idea, cut the fat from it and polish that core.
The good advice for your first game it's something you can finish in six months. This is a godlike advice because in the beginning you get better really fast, but also so you don't get chained by your old bad ideas.
Final note, how dare I to tell someone else to drop a project? If I can persuade him to do it (I have CH1 in my real life build), it means that this project was doomed to begin with.