Oh hon, he's 47!! Reality has kicked in and he's realised that he doesn't want to start all over again. For a guy of this age, it's hardly surprising. Your headline makes this all about you (he doesn't want to have baby with me), but it's better to look at this in a more factual way: He doesn't want a baby. Period.
You're only 25 and you have your whole life in front of you. If his goals and yours aren't compatible, then you need to find someone who is compatible with you. There will be love and a family in your future - just not with this guy.
Never regret anything that has happened in your life. It cannot be changed, forgotten or undone. So, take it as a lesson learned and move on.