Yes you will not be “end device certified” as the Nova is (as Hologram mentioned) the end device certification is made easier by having a module that is already certified (much like FCC testing).
The Sparkfun module should work fine with a Hologram simcard even if it is connecting to the Verizon network. If you use another MVNO’s simcard or a specific carriers simcard then you may need to do carrier end device certifications.
Regulatory and carrier certification is definitely something to consider when doing your product design especially if it will be relatively high volume. Honestly Verizon won’t notice or care if you have 25 units using a certified module with Hologram simcards in non certified end devices, 2,500 maybe.
Of course if you are required to go through carrier certification it kind of makes the whole advantage of Hologram’s simcards moot as you would be tied to one carrier. Or you bite the bullet and do multiple carrier end device certifications like the Nova.
Lastly, my 2 cents, if you are high enough volume where carrier certification is something you need to pursue then I strongly suggest designing your own PCB and not using shields / Arduino’s etc. There is a huge convenience / hobbyist markup on those boards and custom PCBA’s are fairly cheap at volume. Additionally if you fail for some reason, such as TIS / TRP you have no way to fix it without a custom board anyway.