I'm no expert but: It looks to me as though the photo is taken at an angle (ie: the top of the photo is further away than the bottom), the F stop is towards the mid to lower range so the depth of field is not very great. The sharpest part of the photo is about 1/3 up the photo so the focus dies of towards the top. I think if you had shot the photo at f/16 or even f/11, more of the image would have been in focus.
This would have slowed down your shutter speed but not to the degree that camera shake would have become an issue with 24mm hand held.
For a better understanding of depth of field etc. I have found the following website really useful - particularly the free on-line photography course: https://chrisbrayphotography.com/tips/
Could be the brightness of your screen but, if you are shooting RAW the image you export to post processing (LR) is more than likely to look darker.
This is because the image on your camera's display has been "processed' to JPEG whereas the RAW image still needs processing (hence sending it to LR).
A good site to look at to explain this better than I can is: https://chrisbrayphotography.com/tips/
Your camera ( and i guess all cameras ) has no idea you are on a tripod and my guess is that at any shutter speed faster than 1/40 sec. for a 40mm lens Auto ISO will probably go to ISO 100 automatically.
This feature is likely more useful in low light where you need a reasonably fast shutter speed to prevent blurry images while still getting low noise (and that is likely why it is limited to ISO 800)