Perspective of a current "digital nomad" that grew up in the area:

The weather is great in a sense that it's warm, but be prepared for sweltering heat and humidity for ~340 days of the year. Especially during the summer, it's hard to be outside for more than a few minutes without needing a shower.

Lots of outdoors stuff to do like you mentioned, especially water-oriented activities. If you surf, New Smyrna is the most consistent spot but even that's not nearly as consistently good as it is consistently sharky.

High speed internet would be no problem. Brevard and the surrounding areas are red but I wouldn't necessarily consider it cultural backwater. You'll be exposed to a much higher number of crusty beach people (especially in Cocoa Beach) than you will rednecks or similar.