You can only marry him and become Queen-consort if you are a Female Human Noble. On the other side, if Alistair is "hardened", you can still convince him to go on with the relationship by telling "nobody can force the King to make things he doesn't want to".