The reason higher-level scripting languages like Python, etc. exist is that they trade developer time for CPU time. A Python application might run the same task slower than C++, but it probably took a fraction of the time to write. I don't think you're going to see the majority of the community using C++ exclusively because it would dramatically increase the complexity of getting started.
I don't think it's wise to compare Godot to Unity in this respect. As a commercial entity, Unity has very different priorities.
Speaking personally C++ is so far out of what I'm able to understand.
This is going to be true for the majority of users as well to some extent or another. For most use cases, even if you know C++, it's overkill. Often, I just want to make a game - it doesn't matter how it's written because players don't see the code.