It took 18 years to build, has nearly a mile of galleries and is inspired by a desert rose. But is Jean Nouvel’s eye-popping creation for the world’s wealthiest nation too extravagant to fill?