If Barret refuses to use his final limit break in battle, you've probably skipped one of his lower-level techniques. Open the main menu and select Limit, then check Barret's available Limit Breaks. If there's a number missing, you'll need to make sure he learns it before his Catastrophe will be available to use.