Disabling iCloud doesn't enable e2e as the other end of your conversation still has iCloud on by default and is escrowing your chat plaintext to Apple.
Apple has access to all of the plaintext iMessages for almost all devices/conversations and can turn them over to the USG at will.
Even with this on-device CSAM thingy, Apple knows less about you than they did 10 years ago and random staffers at FAANG can't just go and spy on their spouses (the way they could not that long ago).