Indeed, many sauropod species may have a small available primary productivity,
Yes; many are found in fairly dry paleoenvironments.
for example Rapetosaurus in its small island.
Madagascar is not a small island. I repeat: Madagascar is not a small island.