Actually I have been sleeping on a hard mattresses for years. They are/were barely softer than the floor.
Never had any back pains.
And my father's doctor agrees with your doctor, and I have had this kind of bed since my early childhood.
I have trouble sleeping in soft beds of hotels and other places.