Yes, it's likely that you got a bad roll. Since there's only 10 yards of it left, you're kind of S.O.L. on it, though- unless you have a good rapport with your sales rep and can show them the issue. You probably won't get credit for the entire roll, but you can probably get a partial.
Had an order five years ago (give or take) we were doing for a manufacturer. They sent 60 some-odd pallets of 54" and 60" media for printing and the first five rolls (five different printers) were delivering horrid results. Tried a different pallet (and different size. Same thing. Tried another pallet. Nope. Checked the numbers on the boxes and all of them were from the same production line, run within days of each other, so our GM calls the manufacturer's rep who handled the job and asked "what gives?" They gave us the run-around for a few weeks, and were trying everything they could to blame us- despite the fact that we had created our own profiles for the media and that each printer had been "certified", along with the ink and our production and processing methods, by the same manufacturer. After a lot of back and forth, the rep finally admitted it was a known issue with that particularly run that the company "had on hand", so they sent it to us, hoping we'd magically be able to make it work (even though, you know, no one else had been able to). They knew it was garbage media, and tried to pass it on anyway. They ended up with a few hundred "free" rolls of media that we used for shipping labels and freebies.
I'm not saying Arlon did the same with that roll- but... anyone remember Avery's issues back in the late 90s-early 2000s? It turned me off of using their vinyl for more than a decade.
One issue that is getting missed or passed over , though, is that the profiles (even the ones from the manufacturers themselves) are set up for ideal conditions (new printers, new heads, brand new ink, brand new material, perfectly controlled climate and humidity, etc.). Which means they're a good starting point, but they aren't, necessarily, the right profile to use. I'm not saying they don't work, just pointing out that they may not work right. Speaking from experience, there's every chance you find a profile that works- but there's an equal chance you won't. No matter what you do.
The only way you can be certain of your results is creating your own profiles (and then you'll know for certain that a given material has a defect). Yes, that can be time consuming (at least when you're just starting them), but it is the best way to get proven results. Due to the time involved, it's completely understandable if the canned profiles are "good enough", but- if you have exacting customers, or want to make sure that the PMS186 you printed three months ago matches the PMS186 you print as a replacement in six months- it's a necessary step.
As for the media prices- I haven't had to do any purchasing in a while, but might I suggest trying GFC? I always got good results from their products at an excellent price point.
