A luxury yacht that fire officials say was loaded with "1,000 rounds of unspent ammunition and fireworks" has been captured on video sinking at a marina in California after bursting into flames.