I've done this test in the past. The typical footprint of default Prometheus is around 100MiB of RSS.

Removing everything but flie and static configs reduces it to about 50MiB.

Interesting for more embedded use cases, but not really a big deal when you're using a few GiB of memory for TSDB ingestion buffering.