In need of a mans/males perspective, please (but any advice will help) ... have I put my foot in it?

You may have made it awkward, don't text him soon though unless he texts you, otherwise you may seem needy and annoying.