What happens when you reveal an attachment card with museum curator? Are you allowed to attach it to someone or no?

If it's a support card (and most attachments are) then put it into play - in this case by attaching it to a character.

As long as you meet all attachment criteria, then yes you can attach it immediately.