[3.13] Docs: Upgrade Sphinx to 7.4 (GH-121987) (#122010)

Docs: Upgrade Sphinx to 7.4 (GH-121987)
(cherry picked from commit 420d94312824825a18fa1fd9a36773626a54d97a)

Co-authored-by: Adam Turner <9087854+AA-Turner@users.noreply.github.com>
diff --git a/Doc/requirements.txt b/Doc/requirements.txt
index b47a9d8..98ad52e 100644
--- a/Doc/requirements.txt
+++ b/Doc/requirements.txt
@@ -6,12 +6,12 @@
 # Sphinx version is pinned so that new versions that introduce new warnings
 # won't suddenly cause build failures. Updating the version is fine as long
 # as no warnings are raised by doing so.
-sphinx~=7.3.0
+sphinx~=7.4.0
 
 blurb
 
-sphinxext-opengraph==0.7.5
-sphinx-notfound-page==1.0.0
+sphinxext-opengraph~=0.9.0
+sphinx-notfound-page~=1.0.0
 
 # The theme used by the documentation is stored separately, so we need
 # to install that as well.