a pipeline does not ruin a shit ton of land. a small stripe through the middle of farm fields and gets replanted.
the oil would be going to refineries for refining mostly, the US is a huge exporter of refined products to a lot of places. some of our imported crude gets exported as refined products.
anyhow....
offshore wind jobs are the same as you describe for the pipeline. lots of jobs for construction, not that many for maintenance.
the sphere thing is interesting, but it seems problematic to be adding and removing buoyancy to the system, this would seriously stress cycle however they are holding it to the ocean floor. and i would imagine a maintenance nightmare in salt water with continually cycling between air and salt water.