I think Posthog is more like an open source mixpanel -- you need event tracking on your website, and standard analysis of traffic, funnels, user segments etc.

Evidence is aimed at a longer tail of data analysis -- you have more idiosyncratic data landing in a data warehouse, and you need to turn it into custom reports, dashboards etc.