q-parabolicity of stratified pseudomanifolds and other singular spaces