Well, you're right. A limp dick will get bigger but you won't get a bigger dick on erection. It's just helping the blood getting there. That's all. Same thing with penis pumps.
You can also damage your penis with a pump. It's not a magical device you have to be careful.