Could you share an example of a successful DNS lookup for a domain that you expect to be blocked, please?
Whether Pi-hole would block a given porn site at all, or to which extent it would do so, would entirely depend on the blocklists that you chose to employ.
Any complaints concerning quality or content of those blocklists should be addressed with the respective blocklist maintainers.