Do I need to uninstall the insightIDR agent from machines that have the install from the .sh installer and reinstall the agent using the rpm package?
No that is not necessary, you should just update any mass deployment scripts/tools to use the new rpm package moving forward
David