Looking at their docs it seems 3 requests per second is the limit, this could easily be reached at peak times for a blog/website with even the slightest bit of traction.
Many of my customers blogs were on the front page of HN multiple times, and no they did not go down.
The reason being I host everything on cloudflare workers and have a Bunny CDN in front of it. So all the Notion content stays in Bunny Edge Storage in the form of JSON.
When you get a visit, I read from Bunny storage/CDN instead of reading directly from Notion. So, yeah, it won't get rate limited.