Does an erection mean a guy is horny and wants sex?

yes

yes