I'd say give it a shot. Worst comes to worst, you get freaked out, close the game, and come back to it at a later time when you're more prepared to face whatever might've scared you.
If it makes you feel any better, most of the scares aren't gonna make you lose any progress in your game. Usually it's a one-off "BOO!" and the spooky thing often leaves. The dev doesn't really do jumpscares all that often. The only ones I can think of that are in the current version of the game are mainly thanks to information that I got from other players who warned me about it ahead of time.
The ambient mode is always there, and you can just make a different save file and transfer things over to a new game via the mailbox if you're feeling especially terrified/nervous in one of your saves.
Any time you get especially scared, I'd suggest reciting the Bene Gesserit litany against fear. It's something I do that helps to remind me that it's just a game and I'm not actually in any kind of danger.
The litany goes: "I must not fear. Fear is the mind-killer. Fear is the little-death that brings total obliteration. I will face my fear. I will permit it to pass over me and through me. When it has gone past, I will turn the inner eye to see its path. Where the fear has gone, there will be nothing - only I will remain."
(Also I'd suggest reading the original Dune books written by Frank Herbert, but that's off-topic.)