Mechanical Response of Carbon Nanotubes under Molecular and Macroscopic Pressures