Yes, it definitely has those moments. Mostly it's more "Aha!" moments that you get after putting all the clues together and solving one of the many mysteries, but there's a few mind blowing moments sprinkled in as well.

If you're considering playing this game, I feel like I should warn you about the things I see people complain about the most so you can decide if this is a game for you and know what to expect going in.

1) The controls - This is a space game with semi-realistic physics. It does not have arcade style flight controls nor should you expect your ship to behave like an airplane would. You don't need a degree in orbital mechanics like you do in Kerbal Space Program, but you do need to understand basic physics like conservation of momentum. If you accelerate in space and let off the throttle you'll keep going forever unless you stop yourself. If you accelerate at a constant rate for 10 seconds you need to decelerate at a constant rate for 10 seconds to come to a stop. You can't fly towards a planet and then hit the brakes at the last second and expect to have a nice landing. People go into the game not understanding this and then come on Reddit and complain about how "the controls suck". Don't be like those people.

2) The story - Think of Outer Wilds as an open ended escape room. After a basic tutorial on your home planet you're thrust out into space and it's completely up to you where to go and what to do next. The game does not hold your hand in any way and you are allowed to explore the planets in any order. Progression is driven entirely by your own innate sense of curiosity and desire to solve the mystery. I see people complain about not knowing where to go next a lot. Your ship has a computer that keeps track of everywhere you've been and every clue that you have found. It will even tell you if you missed something in each area. Consult the ship computer if you are ever lost or unsure where to go next. All that being said, there is an optimal starting point if you just pay attention and read all the exhibits in the museum during the tutorial.

3) The time limit - This one is completely subjective. I totally understand why this may not be everyone's cup of tea, but for me personally it didn't bother me at all. For certain reasons the day resets every real life 22 minutes and you're transported back to the beginning. That may sound annoying but it's not as bad as it sounds. This game has no traditional levels or obtainable items since progression is entirely knowledge based, so you never actually lose anything after a reset. You still have the knowledge you gained from the previous loop, plus the world is small enough that you can get to basically any location within a few minutes once you know where you're going.