The Life And Death of Interstellar Turbulence: The Intriguing Case of Ophiuchus