It’s actually not bad to do it as long as your host machine has a static ip

Yeah, that’s reasonable

install pfsense in a VM where the host machine gets it’s ip from the VM

This not so much

If you have a family the second the Internet is not working you will be blamed.

Lol, I get blamed enough for DNS, I don’t need routing too