Fix CMake example code in embedding docs

[skip ci]
diff --git a/docs/compiling.rst b/docs/compiling.rst
index 9320fd2..91e65df 100644
--- a/docs/compiling.rst
+++ b/docs/compiling.rst
@@ -203,7 +203,7 @@
 
     find_package(pybind11 REQUIRED)  # or add_subdirectory(pybind11)
 
-    add_executable(example MODULE main.cpp)
+    add_executable(example main.cpp)
     target_link_libraries(example PRIVATE pybind11::embed)