Offshore Wind in the Energy Transition: A Comparative Analysis of Floating and Bottom-Fixed Technologies