InfoPath just follows the same codesigning methodology and security model as signing any ActiveX control, EXE, CAB etc. So this discussion applies equally to both and the considerations for codesigning ActiveX, EXE, CAB, etc. apply equally to signing InfoPath XSN templates.
You are correct that the security of root certificates needs to be high so not just anyone can sign anything with that certificate. As you pointed out that would not be secure. The reason is that typically such certificates are pushed down to all desktops as trusted to make deploying legitimate applications easier.
For that reason, companies have very strict processes which allow only a small number of individuals to codesign using a corporate root or other such certificate. I am not an expert in this area but I know at my former employer (big corp) this was the case.
This is also the case outside corporate certificates. Software is signed with a certificate for distribution online and those Verisign trusted certs are also very valuable. Their integrity has to be protected.
So signing with any certificate that maps back to a trusted root authority (whether inside the corporate firewall or on the Internet) needs to be guarded by secure processes.
Shiraz Cupala
InfoPathDev
Shiraz Cupala / Microsoft InfoPath MVPQdabra® Software / Streamline data gathering to turn process into knowledge