That depends on what you mean by “horizontally oriented”. But if we take it as meaning perpendicular to the radius and parallel to the surface of the Earth (or any other sphere), then no matter which “horizontal” direction you look, you will not be looking directly at the horizon and the angle of depression down to the horizon will be the same in all such directions. So the horizon should appear perfectly straight in any undistorted view of that sort. It will appear curved up at the edges if your line of sight is pointing upwards and down at the edges only if you are looking downwards (which is why all those pictures taken from airplanes claiming to refute “flat earthers” are so silly).
What does show the curvature of the Earth (albeit in a way that is very hard to notice even at the highest commercial airplane altitudes) is the fact that, when you look out “horizontally”, the horizon is below the midpoint of the picture (which is almost impossible to demonstrate convincingly with a photograph since there is no way of proving that the picture has not been cropped from one where the horizon was above the middle).
Of course, if you are far enough from the sphere that the only way any part of it can be in your field of view is by looking downwards (as in the various pictures of the whole Earth taken from space), then you will indeed always see the curvature if you can see any part of it at all. But at any altitude achievable by a commercial aircraft you will almost surely not.
In particular, even at an altitude of 54 km (which is well above most commercial airline cruising heights) we have the following:
An altitude of 54km is just a bit less than 1% of the radius of the Earth, so the angle of depression of the horizon is about arccos(0.99) (* – see first note below if you need an explanation), which is approximately 8 degrees. Since that is about 10% of the 80 degree viewing angle of a 24mm wide angle camera lens, a “horizontally” oriented camera with a wide angle lens at an altitude of 54 km should produce an image of a perfectly straight horizon line about 10% below the middle of the frame. (With a fisheye lens the viewing angle is 180 degrees so with such a lens the horizon should still be a straight line but just [math]8/180\approx 4.4%[/math] below the middle.)
If the camera is pointed down so that the middle of the horizon is at the centre of the frame then with the fisheye lens (if you could put it outside the window, or perhaps be working in the cockpit with a wrap-around canopy window) the horizon should appear as a half ellipse with the edges still about 4.4% down from the middle.
But for a normal wide angle lens, since the half-view width of 40 degrees [per https://expertphotography.com/wide-angle-lens/ ] is less than a half of the 90 degree sweep to the side of the camera, and since the equation of the ellipse is quadratic rather than linear, the edges of the part of the horizon in the picture from that lens will be less than [math]4%/2^2=1%[/math] of the image height below the middle.
And with a telephoto lens of viewing angle just 10–20 degrees, the horizon should only be completely straight if it is right near the bottom of the picture, but the curvature that comes from pointing the camera down to centre the middle of the horizon should be even less noticeable as the image only shows 5 to 10 degrees worth of the drop. (** – See the second note below for the actual calculations)
But at the typical 10km cruising altitude of a commercial airliner there is really no visible effect. The angle of depression of the horizon at that altitude is arccos(0.998) which is less than 4degrees, so in a square picture shot with a normal 50mm focal length showing just the middle 46 degrees of the 180 degree full sweep the drop from centre to edge of the horizon should be less than 0.0015 of the height of the picture (ie just barely one pixel down at the edges in a 640×640 image) – as shown below.
With a 28mm wide angle lens, showing the middle 75 degrees the amount only goes up to about .004 of the image height or less than 2.5 pixels in 640.
With the 94 degree sweep of a 20mm extreme wide angle we still only get a downturn of .0065 of the image height or about 4 pixels in that 640×640 image.
And even with the full 180 degree sweep of the unobstructed fisheye (whose picture compresses what would be in our peripheral vision down into the middle of our field of view and so gives a much more dramatic effect than what we actually see even from that panoramically windowed cockpit) the drop to the edges of the horizon line is only 2% of the image height.
So, while it may be possible for a pilot in a cockpit with good visibility out of front and side windows to get a sense of curvature from peripheral vision, no picture taken from a passenger seat can show curvature unless the camera is pointed downwards (which is a natural thing to do from a plane since most of the interesting stuff is below the horizon).
Here’s what a picture from an ordinary wide angle lens should look like if the camera was pointing ten degrees downwards:
But if you are inclined to see this as evidence of curvature then compare it with the following view of what the same camera would produce looking 10 degrees downwards on a perfectly flat Earth:
(*)-Note1: The picture below shows that the angle of depression, [math]\delta[/math], is the same as the angle subtended at the Earth’s centre between the observer and the point seen on the horizon, whose cosine is just the ratio [math]\frac{R}{R+a}[/math] where [math]R[/math] is the radius and [math]a[/math] is the altitude of the observer.
(**)- Note2: If the edge of a circle is at an angle of [math]\delta[/math] degrees below eye level in all directions, then tilting the view down to bring the part directly in front up to the middle of the picture will not change the fact that the parts off at 90 degrees in the left and right directions are still depressed by an angle of [math]\delta[/math] degrees (and if we had eyes in the back of our head they would be looking up so that the part of the circle behind us would be further down at an angle of [math]2\delta[/math] degrees). Since the projection of a circle is an ellipse, the image of the half-circle in front of us would be given analytically (in terms of the image coordinates [math]x[/math] and [math]y[/math] being the numbers of degrees to the right and above the centre of the image) by the part of [math](\frac{x}{90})^2+\frac{y+\delta}{\delta})^2=1[/math] with [math]y>-\delta[/math] (or parametrically by [math]x(t)=90cos(t), y=\delta sin(t)[/math] for [math]0<t<\pi[/math]). A fisheye lens would produce an image in which the [math]x[/math] and [math]y[/math] values range from -90 to +90, but with a lens of view width [math]w[/math] degrees the ranges in the picture would just be from [math]-w/2[/math] to [math]w/2[/math], and the images shown above were created by just zooming in on a graph of the ellipse so that the relevant ranges of [math]x[/math] and [math]y[/math] fit into the area of the picture.
640*4(1-sqrt(1-(94/180)^2))/90
90cos(t);4sin(t)-4;0,3.14
Source: Alan Cooper’s answer to Why isn’t there any curvature at the horizon when we look out if we live on a ball? – Quora