The talent should give you the two extra ability points immediately after you confirm it. It's also a one-time deal, in other words you only get +2 points once, not every level. If you select it in the character creation screen, you will get the extra points when the game starts (but they won't show up in CC).
I haven't taken this at the start of the game, but I took it afterwards, however I never got the points to my knowledge. I will need to check again. However when I took Bigger is Better I saw the stat points right away. Now this is also more noticeable so I'll have to double check.
Thanks for the info.
