It depends on your genre - in horror games this can be a very good decision
If you are going for a darker themed game, and your description suggests that you are doing this, then having multiple bad endings is fine. I've played quite a few horror games that were created with the RPG Maker (I am not affiliated with the company) for example where there are lots of bad endings - and I enjoyed all of them. Because you spend most of your time in the game itself: The journey is the destination.
Having only bad endings would probably be a bad idea. This would make the player feel like all of their effort was indeed wasted. But if your game makes it obvious that there are multiple endings and each ending gives information about a possible other ending, one of them being good, then everything is fine. If only you had taken the knife with you that the Antagonist just used to stab you, things might have gone a different route...
The players who enjoy playing a game multiple times will try to follow the advice they got. Others might simply look up a walkthrough that shows them the other endings. I've been on both sides, depending on how much time I would need to spend with the same stuff I've already done in previous runs. The more decisions one can do the better. Spending 10 hours only to click Left instead of Right before the Boss' lair is boring. But deciding whether you take the lamp or the book with you after a few minutes is a completely different matter. As long as these decisions matter that is. Having regular checkpoints, especially before important decisions can help, too. If that is your style, of course. Some games prefer to go a rogue-like style and let the players decisions be final when they are deciding which part of the story they want to play.
Having only one good, hard to achieve, ending is especially good for perfectionist gamers that want to get everything. They will try to get every ending and see which hints they contain that will help them get to 100 %.
Furthermore having only one good ending makes this one feel special to the players who manage to achieve it. It's clearly better than any other ending they managed to get and therefore more valuable in their eyes.
What you also sometimes see is that a game has maybe two or three bad endings (plus a Game Over that can for example occursoccur if the player dies) and one good ending. And then one special, true ending that you can only get if you for example collect all of the very rare items. This is another possibility. Make it a little bit easier to have a nice ending to please your more casual gamers and make the true ending extra hard to get and thereby extra rewarding. The true ending doesn't have to be completely happy by the way, though this will surely leave the player with the feeling of having completed a horror game.
But your game has to fit this style. You don't want a totally happy and relaxed game where you suddenly realize at the end that your decisions have led to a bad ending. Imagine for example a Pokemon game (again, I am not affiliated with the company) where you basically have nothing to lose from spending some time trying to catch or train your Pokemon - and in the end you realize that there was a time limit of 100 in-game days to get to the end and now you can't beat the Top Four. That would suck.