I agree that they would take north of the Missouri River, but not that they would take a bit of California. I think that with the acquired territory it could be more difficult to populate the Oregon territory.Spanish Florida could become a tourism Mecca, albeit probably not to the same extent as OTL's U.S. state of Florida. As for an independent Spanish Texas (or Tejas), the oil would help, assuming they handle it prudently. I suspect Spanish Louisiana north of the Missour River at the very least is going to be seized by the British sooner or later, and the Brits taking California (or at least part of it) is also very possible (I think they'll end up getting Cascadia over the Spanish and Russians).
In any case, in this story, it seems that Spain will be better than in otl and for some reason they lose territory in South America, they could redouble their intention in North America and probably reform.