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
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
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,
(**)- Note2: If the edge of a circle is at an angle of
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
Note: For photographs illustrating how the angle of view affects apparent curvature (including its reversal for an upward pointing camera) see Figures 3 and 4 in this article. But be aware of the fact that the “barrel distortion” which that paper attributes to the design of the optical system is actually nothing more than the effect of an undistorted linear projection.