The closest approximation, is having a trusted client. This hashing scheme ruins the "trusted client" and I would no longer consider it e2e.
Not to mention that a database of hashes is trivially to expand with content that isn't CSAM. Next thing we know the European equivalent of the Tankman picture is included in the hash to more effectively pursue political opposition or activists.
This would destroy all ability to protest and singlehandedly eliminate democracy in Europe. I'm not exagerating. Climate activists in Germany are already put in "präventivhaft"[1] (preventive detention) before a civil disobedience / crime occurs. A scheme such as this would make it trivial to do at massive scales.
[1]: https://www.br.de/nachrichten/bayern/staatsregierung-verteid...