Am I going to get bulky, huge or look too big?

Not likely, unless that is your goal. Building muscle is important for fitness but given normal protocols CrossFit will not make you big or bulky. Most CrossFitters are actually quite lean. More muscle helps you burn more calories, become more resilient, and look better naked.