Not necessarily. A civil war between new global tribes* would still be a globally devastating conflict.
* not necessarily the same ones everywhere
http://www.johntreed.net/sittingducks.html
BTW, have you heard about the Russian Zircon missiles?
Ballistic missile submarines are incredible. Each Ohio class has 24 Trident missiles with up to 8 warheads each. That makes each one a bigger nuclear power than everyone except the US, UK, Russia, France, China and Israel.
The Navy's nuclear attack submarines are also fearsome. Much quieter than old nuclear boats, fast and able to be anywhere and fire cruise missiles.
As you point out carriers are now vulnerable. But they can be held out of range and aircraft refueled. They can then deploy aircraft a long way away from them.
1. maintaining logistical access for the Army/Marines (aircraft from carriers, surface combatants, and attack submarines)
2. doing the Air Force's job with lower latency where there are insufficient basing opportunities, especially in low-intensity situations (aircraft from carriers and missiles from surface combatants)
3. higher-survivability forces for the Air Force's job in high-intensity global conflicts (ballistic missile submarines)
The Army is fundamentally a real estate focused organization - their role is to take and hold territory.
The Navy is about slow influence - control of the seas allows you can deploy and retract the threat of physical violence depending on the political situation.
The Air Force is about the ability to deliver devastating violence on space-age timelines. But they still require targets.
My cautiously optimistic view is that these forms of violence become far less relevant when geography is no longer the key dividing line in tribal affiliation. You will see a rise in low level violence, and that will be associated with a decline in the primacy of the nation state. But it will reduce the risk of globally devastating conflict.