People have been running public websites off of the back of their ISPs since the 90s. I know a few today that are nothing but a Raspberry PI running Pocketbase.

It scales for the intended audience.

Self hosting doesn't mean you need to build the next AWS.