Yeah on premises share point is absolutely still a thing. it’s not as common as i get it as microsoft wants you to migrate to share point online and at least clients i talked to said they did the migration because of licensing pressure from microsoft but i cannot comment on that personally.

Share point is just MSSQL in the backend and while setting up share point is mostly a simple affair with clicking through the wizards, managing it can get complex for the inexperienced since there’s a lot going on for on premises. the allure of a quick and easy self hosted share point site vanishes pretty fast once the reality of protecting it and keeping it running hits.