Yes. Similar to adding a photo, you site will increase in size and because of this we normally recommend keeping your web font selection on the conservative side.
You typically don’t need an entire super family.
When creating the webkit, you have the possibility to minimise the file size by choosing different languages and/or OT Features.
For Monotype IP (including FontFonts) you can subset your fonts even more via our subsetter.