Do we wait or pursue sex? NEEDING HELP😫 No judegment!

So me and my boyfriend have been together for a long time now. We have recently talked about having sex. We both feel it's something we should both be ready for and make sure it is special. My biggest fear is after we give our virginity up to each other we may be closer in one way but I don't ever want our relationship to change and for us to get tired of each other. We both agreed that it is something we would do very rarely so it remained special but I just feel like I should get some other people's opinion on the case scenario. Will we get tired of each other? Will our relationship change for better or for worse? How big of a toll will it have on me? Tell me your personal stories! How did sec affect your relationship?!!