US president has hailed the fossil fuel as ‘indestructible’ but weak investor demand plagues the sector