Winds of Progress: An In-Depth Exploration of Offshore, Floating, and Onshore Wind Turbines as Cornerstones for Sustainable Energy Generation and Environmental Stewardship