Your axles are strong enough to last quite a while along with the rest of your drive-train, as long as they weren't beat up prior to the lowering.

Don't let that break your decision to lower a car, It's just an awful rumor
As long as your not looking to Stupid Slam your car to the ground, You should be fine.......Auto or standard transmission.