You could try an oblique view frustrum (in professional photography also known as lens shift) instead of the default symmetrical.
A manipulation of the vanishing point creates an non uniform frustum and lets you see more of the ground without tilting the camera. I think you can create something like this in Godot, otherwise you just need access to the 4x4 camera matrix and change 2 values in it and pass it back to the camera.