Update in 2025:
In the "Settings > Configure Kate > Editing > Auto Completion" menu there is now a "Use Enter key to insert selected completion" toggle that you can turn off. Which is exactly what I think we all wanted.
Confirmed on Kate v24.12.3, if you don't see it check if you can update