Is having second thoughts about something, then realizing that deep down inside you really really do want it normal?
Depends on the importance of the thing you’re having second thoughts about, and other factors as well.
If I go to a restaurant, spend half an hour poring over the menu trying to decide what to eat (when there are only three or four options), then finally make a choice, then spend another half an hour after the food has arrived thinking about how anything and everything else on the menu might have been better - no, that’s not normal.
A decision on what to eat is low on the scale of importance, and isn’t worth wasting that much energy on, especially when you’ve only got a handful of options anyway. And it’s not really like you can change your mind once the food’s arrived anyway.
If I’m considering a college to go to, or a man to marry, obviously there’s a lot more room for reasonable uncertainty and second thoughts. Where it gets to be a problem, and possibly abnormal, is where you’re SO unsure that you can’t even make a decision yay or nay.
For example, if you spend so much time dithering about what college(s) to apply for that you end up missing the application deadlines for ALL of them. Or you spend a semester each in four different colleges, one after the other, because you can’t settle on any one of them.
In a lot of circumstances in life, commitment to a decision, once made, is far more important than making the absolutely “perfect” decision in the first place - in fact there’s often no such thing as the “perfect” decision! Try to gently push aside thoughts of the grass being greener elsewhere once you’ve chosen your paddock.