If you haven't put anything that wide up there before, as it seems to suggest when you say "I finally managed to put in a tampon", you can certainly expect to feel it at first. Same with anything, a nose or lip piercing will be the same but eventually you will start to just not notice it.
.