Honestly, the overhead from TinyPilot is so small that it's just a question of how powerful you want the device for other activities.
Here's a screenshot I took earlier today on a Pi 4 with 2 GB of RAM. TinyPilot is streaming video over WiFi, and top shows that it's only using ~4% of CPU and ~2% of RAM: